ISO vs US week numbers, and other week systems
“What week is it?” has more than one correct answer. Depending on your country, your software and even the spreadsheet function you pick, the same date can be week 1, week 52 or week 53. This guide compares the systems you are most likely to meet, shows exactly where they disagree, and explains how to tell which one a calendar or report is using.
Every system answers two questions
Any week-numbering scheme has to decide:
- Which day starts the week? Usually Monday, Sunday or Saturday.
- Which week is week 1? Either the week that contains January 1, or the first week with a majority (four or more) of its days in January, or the first full week.
The combinations of those two choices explain almost every difference you will see.
ISO 8601 (international)
Weeks run Monday to Sunday and week 1 is the week with the year’s first Thursday — the first week with at least four January days. Weeks never split across years, so a year has 52 or 53 whole weeks, and a few days around New Year can belong to the neighbouring year. This is the standard in most of Europe and in international business. The details are in What is ISO 8601 week numbering.
US convention (Sunday start, week containing January 1)
In the common North American convention, weeks run Sunday to Saturday and week 1 is the week that contains January 1, however few days of it are in January. Week 2 starts on the first Sunday after January 1. Consequences:
- January 1 is always in week 1, so the week number never “belongs” to the previous year.
- The first and last weeks are usually partial. Because a year has 52 weeks plus one or two days, the US scheme always reaches week 53, and in a leap year that begins on a Saturday it reaches week 54 — the most recent was 2000, and the next is 2028 (December 31, 2028, a Sunday, is alone in week 54).
- The week of December 28 – January 3 is split: its December days are the last week of one year and its January days are week 1 of the next.
This is the default of Excel’s and Google Sheets’ WEEKNUM(date) and of many US wall and desk calendars. It is not an international standard; it is simply a long-standing convention.
Where ISO and US numbers differ
For most of the year the two systems are either equal or one apart, depending on the year. Around New Year they can differ dramatically. Here is how a few dates compare (US week numbers count from the week containing January 1, weeks starting Sunday):
| Date | Weekday | ISO 8601 | US (Sunday start) |
|---|---|---|---|
| December 29, 2024 | Sunday | 2024-W52 | Week 53 of 2024 |
| December 30, 2024 | Monday | 2025-W01 | Week 53 of 2024 |
| January 1, 2026 | Thursday | 2026-W01 | Week 1 of 2026 |
| January 4, 2026 | Sunday | 2026-W01 | Week 2 of 2026 |
| December 27, 2026 | Sunday | 2026-W52 | Week 53 of 2026 |
| December 31, 2026 | Thursday | 2026-W53 | Week 53 of 2026 |
| January 1, 2027 | Friday | 2026-W53 | Week 1 of 2027 |
| January 3, 2027 | Sunday | 2026-W53 | Week 2 of 2027 |
| January 4, 2027 | Monday | 2027-W01 | Week 2 of 2027 |
| June 15, 2027 | Tuesday | 2027-W24 | Week 25 of 2027 |
| January 1, 2028 | Saturday | 2027-W52 | Week 1 of 2028 |
| December 31, 2028 | Sunday | 2028-W52 | Week 54 of 2028 |
All values in this table were generated by code and cross-checked against Python’s built-in ISO calendar.
Spreadsheets: WEEKNUM vs ISOWEEKNUM
Excel and Google Sheets expose both families through one function and a return type argument:
| Formula | Week starts | Week 1 is… |
|---|---|---|
WEEKNUM(A2) or WEEKNUM(A2,1) | Sunday | the week containing January 1 (US) |
WEEKNUM(A2,2) or WEEKNUM(A2,11) | Monday | the week containing January 1 |
WEEKNUM(A2,12) … WEEKNUM(A2,17) | Tuesday … Sunday | the week containing January 1 |
WEEKNUM(A2,21) | Monday | the week with the first Thursday (ISO) |
ISOWEEKNUM(A2) | Monday | the week with the first Thursday (ISO) |
Note the trap in the second row: WEEKNUM(A2,2) starts weeks on Monday but is still not ISO, because week 1 is the week containing January 1. On Friday, January 1, 2027 it returns 1, while ISOWEEKNUM returns 53. Microsoft calls the January-1 method “System 1” and the ISO method “System 2”.
Monday start with the week containing January 1
Some organizations and older software use Monday-start weeks but still call the week containing January 1 “week 1”. It looks like ISO for most of the year, but it disagrees with ISO in every year whose January 1 falls on a Friday, Saturday or Sunday — about three years in seven. If a supplier’s week numbers are consistently one higher than yours in such a year, this is usually why.
“Week 0” systems
Several programming tools count only full weeks, and call the days before the first Sunday or Monday “week 0”. The C and Python strftime codes %U (Sunday start) and %W (Monday start), and MySQL’s WEEK(date) default mode, work this way. On January 1, 2026 (a Thursday) all of them return 0, while the ISO week is 1 and the US week is 1. These functions are fine for internal grouping but should not be shown to people as “the week number”.
Saturday-start weeks
In much of the Middle East and North Africa the traditional week begins on Saturday, because the weekly day of rest falls on Friday. Printed calendars in many Arab countries therefore show Saturday in the first column. Week numbers are less common in daily life there, but when they are needed, spreadsheet users can get Saturday-start weeks with WEEKNUM(date,16). Weekend days also vary — many countries in the region rest on Friday and Saturday — which matters for business-day calculations more than for week numbers.
Fiscal and retail week calendars
Many businesses run a fiscal year made of whole weeks so that every period has the same number of weekdays and weekends. Common patterns are the 4-4-5, 4-5-4 and 5-4-4 calendars, where each quarter has 13 weeks grouped into periods of four or five weeks. A fiscal year might be defined as ending on the last Saturday of January, or on the Saturday nearest the end of a month. These years contain 52 weeks, with a 53rd week added every five or six years. Fiscal week 1 can start months away from January 1, so always check the company’s own calendar.
How to tell which system a source uses
- Look at the first column of the calendar: Monday-first usually means ISO; Sunday-first usually means the US method.
- Look at the first days of January in a year starting on a Friday, Saturday or Sunday (such as 2027, 2028 or 2033). If January 1 is labelled week 52 or 53, it is ISO; if it is week 1, it is a January-1 method.
- Check for a week 54 or a week 0 — only non-ISO systems produce them.
- In data exchanged between countries or companies, prefer the unambiguous ISO notation such as
2027-W01.
The tools on this site show both ISO and US numbers. Switch between them with the ISO / US toggle on the home page or in the calendar.