Examples

ISOWEEKNUM("1/1/2021") : 53

ISOWEEKNUM("1/4/2021") : 1

ISOWEEKNUM(TODAY()) : Today's ISO week number.

Syntax

ISOWEEKNUM( when )

Arguments

  • when (Date or DateTime)

Return Value

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

See Also

EOMONTH(), WEEKDAY(), WEEKNUM(), WORKDAY()

Did this answer your question?