WEEKNUM function

Description

WEEKNUM(date) returns the number of the week of the year of date. Date can either be a serial date number or a date string.

Examples

When using date format MM.DD.YY:

WEEKNUM("01.01.98") returns 1

WEEKNUM("02.05.98") returns 6

WEEKNUM("12.25.98") returns 52

Calculator

WEEKNUM()

Related functions

This site uses cookies to store information on your computer. More info...