Returns the number of the ISO week of the year (1 to 53) for the specified date. If the date is not valid, 0 is returned.

Sample Usage

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

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

ISOWEEKNUM(TODAY()) returns today's ISO week number. See also TODAY()

Syntax

ISOWEEKNUM( date )

  • date - Textual value (in quotes) or expression that resolves to a Date or DateTime value.

See Also

EOMONTH()

WEEKDAY()

WEEKNUM()

WORKDAY()

Did this answer your question?