ISOWEEKNUM function

ISOWEEKNUM(date) ISOWEEKNUM(date)

date — Number or { Number }

The date, as a sequential serial number.

Returns — Number or { Number }

The ISO week number of the given date, from 1 through 54.

Returns the ISO week number of the given date, from 1 through 54. Weeks begin on Mondays, and week number 1 is the first week of the year that contains a Thursday.

Examples

ISOWEEKNUM(DATE(2008, 1, 1))ISOWEEKNUM(DATE(2008; 1; 1))

Returns 1.

ISOWEEKNUM(DATE(2008, 12, 24))ISOWEEKNUM(DATE(2008; 12; 24))

Returns 52.