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

Want to practice ISOWEEKNUM in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=ISOWEEKNUM(date) Explain

Arguments

ArgumentRequired?What it does
dateYesThe 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.

B2fx=ISOWEEKNUM(A2)
AB
1DateISO week
21/1/20261
33/15/202611
41/1/202753
51/4/20271
=ISOWEEKNUM(A2) Explain

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.

=YEAR(A2)&"-W"&TEXT(ISOWEEKNUM(A2),"00") Explain

Common mistakes

  • Week 53 in January. That's correct ISO behaviour — the date belongs to the previous year's last week.

Notes

  • =WEEKNUM(A2,21) gives the same answer.
  • Related functions: WEEKNUM, WEEKDAY.
Kyle Stott

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.