Correct ISO logic
Proper ISO 8601 rules, including the week-year that can differ from the calendar year.
Find the ISO 8601 week number for any date, along with the week-year it belongs to, the Monday it starts on, the Sunday it ends on and how many weeks are left in the year.
| ISO week | Starts (Mon) | Ends (Sun) | Week-year |
|---|
Calculated in your browser using standard ISO 8601 rules.
Proper ISO 8601 rules, including the week-year that can differ from the calendar year.
See the Monday start, Sunday end and where the date sits within the year.
The US Sunday-start number is shown alongside so cross-team confusion disappears.
Pick any date and the ISO week is worked out from the standard Monday-to-Sunday rule.
ISO 8601 gives every week a number from 1 to 52 or 53, always running Monday to Sunday. Manufacturing, logistics and European business planning lean on it heavily, because a week number is unambiguous across languages and date formats. The one wrinkle is the year boundary, where the last days of December can belong to week 1 of the next year and the first days of January to week 52 or 53 of the last.
A week belongs to whichever year contains its Thursday. This is equivalent to saying week 1 always contains 4 January.
Because of the Thursday rule, the year a week belongs to can differ from the calendar year of a given date within it.
Roughly every five to six years the calendar produces 53 ISO weeks, which is a recurring headache for annual financial planning.
In the United States, weeks generally start on Sunday and week 1 is simply the week containing 1 January, giving a different number for most dates.
Questions about ISO rules, week-years and spreadsheet differences.
Week 1 is the week containing the first Thursday of January, which is the same as the week containing 4 January. Weeks always run Monday to Sunday.
If 1 January falls on a Friday, Saturday or Sunday, those days belong to the last week of the outgoing year under ISO rules. That is why the tool reports a week-year separately from the calendar year.
Most years have 52 ISO weeks. A year has 53 when it starts on a Thursday, or when it is a leap year starting on a Wednesday.
Spreadsheets default to a US convention where weeks start on Sunday and week 1 is simply the week containing 1 January. This tool shows both so you can see the difference.
Most of Europe plus much of Asia use them for business planning, logistics and manufacturing schedules. North America generally uses the Sunday-start convention instead.