WEEKNUM()

Returns the week of the year as a Number (1 to 53) if date is recognized, or 0 if not.

Sample usage

WEEKNUM("1/1/2019") returns 1

WEEKNUM("12/31/2019") returns53

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

Syntax

WEEKNUM(when)

• when - A Date or DateTime value.

See Also

EOMONTH()

ISOWEEKNUM()

WEEKDAY()

WORKDAY()