Formulas and Functions
ISOWEEKNUM
The ISOWEEKNUM function returns the ISO (International Organization for Standardization) week number for a specific date.
ISOWEEKNUM(date)
date: A cell reference containing a date or a function that returns a date.
Notes
ISOWEEKNUM uses the ISO 8601 standard.
Examples |
|---|
If A1 contains 2022-03-01: =ISOWEEKNUM(A1) returns 9. If A1 contains 3, A2 contains 1, A3 contains 2022, and A4 contains =DATE(A3,A1,A2): =ISOWEEKNUM(A4) returns 9. |
See alsoDATE