ISO Week vs Calendar Week — Key Differences
Updated: May 2026
When someone says "week 12," they may mean something completely different depending on which system they use. ISO weeks and simple calendar weeks follow different rules for the start of the week, the definition of week 1, and how late-December or early-January days are assigned.
Free · No account · 100% in-browser
Side-by-side comparison
| Rule | ISO week (ISO 8601) | US calendar week |
|---|---|---|
| First day of week | Monday | Sunday |
| Week 1 definition | Week containing first Thursday of the year | Week containing January 1 |
| Standard | ISO 8601 (international) | No formal standard; varies by software |
| Partial first week | Belongs to previous year (week 52 or 53) | Counted as week 1, even if only 1 day |
| Weeks per year | 52 or 53 (complete weeks only) | 52 or 53 (first/last may be partial) |
| Common regions | Europe, international standards | United States, Canada |
The start-of-week difference
The most immediate difference is which day starts a week. ISO weeks always start on Monday. Many Anglophone countries, and most US software tools such as older versions of Microsoft Excel, count weeks starting on Sunday. This shifts every week boundary by one day.
For a given date in mid-year, the two systems usually agree on the week number. But at year boundaries, or when comparing calendar grids generated by different tools, you can see a one-week discrepancy that is caused entirely by this start-day difference.
Google Calendar in US locale shows weeks starting on Sunday by default. You can change this in settings to Monday. The week number displayed in the sidebar changes accordingly — which system it uses depends on your locale.
The week 1 definition difference
ISO week 1 is the week containing the first Thursday of the year. This means week 1 always has at least four days in January. A simple calendar week system assigns week 1 to whichever week contains January 1, even if only one day of that week is in the new year.
The practical effect: in a year where January 1 is a Sunday (as in 2023), the ISO system places that single Sunday in week 52 of the previous year, and starts week 1 on January 2 (Monday). A Sunday-start calendar system would call the week of January 1 "week 1," giving the full year one more week label and potentially ending on a different week number.
When the difference actually matters
For most day-to-day purposes the two systems agree. Week 15 in April is week 15 in any system. The difference becomes significant in:
- Cross-border reporting — if a US team exports a "week 1" report and a European team reads it as ISO week 1, the date ranges may not match at year start.
- Database queries — SQL
WEEK()has a mode parameter (0–7). Mode 3 gives ISO weeks. Using the wrong mode produces silently incorrect aggregations near year boundaries. - Spreadsheet formulas — Excel's
WEEKNUM()defaults to Sunday start.ISOWEEKNUM()gives the correct ISO result. They disagree on January dates most years. - API integrations — one partner might use ISO week, another a Sunday-based week, and both might call it "week number" without clarifying the convention.
Which one should you use?
ISO weeks are the international standard. If you work across borders, exchange data with partners in Europe, or build systems that must be unambiguous, use ISO 8601. The notation is explicit: 2026-W22 cannot be misread the way a bare "week 22" can.
If you operate within a US-centric software environment where Sunday-start weeks are the default everywhere, matching that convention may reduce confusion for your team — as long as you never exchange week numbers with ISO-based systems without converting.