Skip to main content

ISOWEEKNUM

The ISOWEEKNUM function returns the ISO week number of the year for a given date.

Syntax​

=ISOWEEKNUM(date)

Parameters​

  • date: The date for which you want to determine the ISO week number

Examples​

=ISOWEEKNUM("2024-01-01") // Returns 1
=ISOWEEKNUM("2024-12-31") // Returns 53 (if it's week 53)
=ISOWEEKNUM(TODAY()) // Returns the current ISO week number