ISOWEEKNUM function
ISOWEEKNUM returns the ISO 8601 week number, 1 to 53, where weeks start on Monday and week 1 contains the year's first Thursday. Use it when reports must match ISO calendars.
Example
Read it as a sentence: find the ISO week number of the date in F1. F1 is empty, which counts as day 0 of 1900, so the answer is 52.
Excel shows 52
F
1
Data
Syntax
ISOWEEKNUM(date)
-
date(required) - The date to evaluate.
Returns: The ISO 8601 week number, 1 to 53.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISOWEEKNUM(DATE(2026,1,1)) | 1 | Thursday Jan 1 |
=ISOWEEKNUM(DATE(2027,1,1)) | 53 | Friday Jan 1 |
=ISOWEEKNUM(DATE(2021,1,3)) | 53 | Sunday Jan 3 |
=ISOWEEKNUM(DATE(2026,12,31)) | 53 | Year end |
=ISOWEEKNUM("1/9/2026") | 2 | Text date |
=ISOWEEKNUM(Data!F1) | 52 | Blank |
=ISOWEEKNUM("x") | #VALUE! | Bad date |
=ISOWEEKNUM(-1) | #NUM! | Negative serial |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
Data
Watch out for
- Early January days can belong to week 52 or 53 of the prior year, and late December to week 1 of the next.
- WEEKNUM defaults to a different system, so the two often disagree.
Where it works
- Excel
- ISOWEEKNUM arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .