Syntax

WEEKNUM(when)

Arguments

  • when (Date or DateTime)

Return Value

Number: The week of the year as a number (1 to 53) if when contains a recognizable date, or 0 if not.

Examples

WEEKNUM("1/1/2019") : 1

WEEKNUM("12/31/2019") : 53

WEEKNUM(TODAY()) : Today's week number.

See Also

EOMONTH(), WEEKDAY(), WORKDAY()

Did this answer your question?