Returns the ISO 8601 week number of the year for a given date.
Синтаксис
ISOWEEKNUM(date)Аргументы
dateобязательно
The date for which you want to find the ISO week number.
The ISOWEEKNUM function calculates the week number based on the ISO 8601 standard, where the week starts on Monday and the first week of the year contains the first Thursday. This function is useful for international business reporting where a consistent weekly calendar is required.
=ISOWEEKNUM("2023-01-05")→1Returns 1 because January 5, 2023, falls in the first ISO week of the year.
Select a cell
Click on the cell where you want to display the week number.
Enter the formula
Type =ISOWEEKNUM( followed by a date reference or string, then close the parenthesis.
ISOWEEKNUM strictly follows the ISO 8601 standard, while WEEKNUM allows for different return types to define which day the week starts on.