WEEKNUM function

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

Related functions

• List of Date and time functions