The ISOWEEKNUM function returns the ISO week number of the year for the specified date.
This function can be useful for analyzing data by week, especially in business and financial reporting.
Syntax
ISOWEEKNUM(date)
Argument |
Description |
Permitted values |
|---|---|---|
date |
Date for which the week number according to the ISO standard is required |
Reference to a cell containing a date, a function that returns a date value, a row containing a date in a valid format |
Examples of use
Determining the week number for a specific date
=ISOWEEKNUM("01/15/2023")
This formula will return the number 2, as January 15, 2023 falls in the second week of the year according to the ISO standard.
Use with a cell
=ISOWEEKNUM(A1)
If cell A1 contains a date, the function will return the week number for that date.
Notes
–The ISOWEEKNUM function follows the ISO 8601 standard, where the week starts on Monday and the first week of the year is the week that contains the first Thursday of the year.
–Make sure the date is set in the correct format to avoid errors.