ISOWEEKNUM Function
Returns the ISO week number of a date.
Category
Date & Time
Available in
Excel 2013+, Microsoft 365
Returns
An ISO week number from 1 to 53
Overview
ISO weeks run Monday to Sunday, and week 1 is the week that contains the year's first Thursday. Many businesses and most of Europe plan by ISO weeks.
Because of that rule, the first days of January can belong to week 52 or 53 of the year before.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| date | Yes | The date. |
Examples
Example 1 — ISO weeks around New Year
January 1, 2027 is a Friday, so it still belongs to the last ISO week of 2026.
| A | B | |
|---|---|---|
| 1 | Date | ISO week |
| 2 | 1/1/2026 | 1 |
| 3 | 3/15/2026 | 11 |
| 4 | 1/1/2027 | 53 |
| 5 | 1/4/2027 | 1 |
Example 2 — A week label like 2026-W11
Join the year and week. For dates in late December or early January, the ISO year can differ from the calendar year.
Common mistakes
- Week 53 in January. That's correct ISO behaviour — the date belongs to the previous year's last week.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.