All functions / Date & Time

ISOWEEKNUM

The ISO 8601 week number: weeks start on Monday, and week 1 contains the first Thursday of the year.

Syntax

=ISOWEEKNUM(serial_number)

Arguments

• serial_number: A date (or a cell containing one).

Example

=ISOWEEKNUM(DATE(2024,12,30)) → 1