Quick answer
ISO weeks start on Monday. Week 1 is the week containing January 4, and a date near New Year can belong to a different ISO week-year.

Step by step
- Find the Monday of the week containing January 4 for the ISO year you want.
- Add seven days for each week after week 1. For week 10, add nine weeks. The week ends six days after that Monday.
- Check the boundary if the date falls near New Year. In a spreadsheet, ISOWEEKNUM gives the week number, and the Thursday in the same week gives the ISO week-year.
Worked example
January 1, 2021 is in ISO week 53 of 2020. That week starts Monday, December 28, 2020 and ends Sunday, January 3, 2021.
Find the ISO week-year and Monday by hand
ISO weeks run from Monday through Sunday. Week 1 contains January 4. Once you locate the Monday of that week, you can count complete seven-day offsets to find later week starts.
| Scenario | Inputs | Calculation | Result |
|---|---|---|---|
| New Year in the preceding ISO week-year | 2021-01-01 | Week of 2020-12-28 is 2020-W53 | 2020-W53 begins 2020-12-28 |
| First Monday of a new ISO year | 2021-01-04 | Week of 2021-01-04 is 2021-W01 | 2021-W01 begins 2021-01-04 |
| December already in week one | 2025-12-29 | Week of 2025-12-29 is 2026-W01 | 2026-W01 begins 2025-12-29 |
| Start of a year on Thursday | 2026-01-01 | Week of 2025-12-29 is 2026-W01 | 2026-W01 begins 2025-12-29 |
| Sunday before a new ISO year | 2027-01-03 | Week of 2026-12-28 is 2026-W53 | 2026-W53 begins 2026-12-28 |
| Middle of an ISO week-year | 2026-07-15 | Week of 2026-07-13 is 2026-W29 | 2026-W29 begins 2026-07-13 |
New Year in the preceding ISO week-year
Write each part of the input on its own line before doing the calculation. This makes it easier to compare your work with the setup and to find the first place where your answer differs.
- Inputs
- 2021-01-01
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2020-12-28 is 2020-W53
- Result
- 2020-W53 begins 2020-12-28
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
First Monday of a new ISO year
Try this case on your own using the method in the quick answer. Keep the original input in view while working. The intermediate calculation below gives you a checkpoint before you compare the final result.
- Inputs
- 2021-01-04
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2021-01-04 is 2021-W01
- Result
- 2021-W01 begins 2021-01-04
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
December already in week one
Make a rough estimate first, using the size of the numbers and the units shown. A result that is off by a factor of sixty or by a whole date is often easier to spot with an estimate beside it.
- Inputs
- 2025-12-29
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2025-12-29 is 2026-W01
- Result
- 2026-W01 begins 2025-12-29
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Start of a year on Thursday
Do this example independently. Copy the complete inputs, including any labels that determine the interpretation. Then use the setup to decide which operation comes first and what the final answer should describe.
- Inputs
- 2026-01-01
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2025-12-29 is 2026-W01
- Result
- 2026-W01 begins 2025-12-29
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Sunday before a new ISO year
Use this case to check what happens at a boundary or when changing formats. Write the intermediate value separately from the displayed answer so you can tell whether a discrepancy comes from the calculation or from the presentation.
- Inputs
- 2027-01-03
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2026-12-28 is 2026-W53
- Result
- 2026-W53 begins 2026-12-28
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Middle of an ISO week-year
Save the original values and repeat the calculation using a different representation if one is available. Compare the intermediate result before rounding or formatting so you know whether the two approaches agree.
- Inputs
- 2026-07-15
- Setup
- Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years.
- Calculation
- Week of 2026-07-13 is 2026-W29
- Result
- 2026-W29 begins 2026-07-13
Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Steps to check against your own records
- New Year in the preceding ISO week-year. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- First Monday of a new ISO year. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- December already in week one. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Start of a year on Thursday. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Sunday before a new ISO year. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Middle of an ISO week-year. Find the Monday of the given date’s week. Compare the date against the Mondays of the January 4 weeks for the surrounding years. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Try the examples before revealing the answers
- New Year in the preceding ISO week-year. 2021-01-01. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2020-12-28 is 2020-W53 gives 2020-W53 begins 2020-12-28. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- First Monday of a new ISO year. 2021-01-04. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2021-01-04 is 2021-W01 gives 2021-W01 begins 2021-01-04. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- December already in week one. 2025-12-29. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2025-12-29 is 2026-W01 gives 2026-W01 begins 2025-12-29. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Start of a year on Thursday. 2026-01-01. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2025-12-29 is 2026-W01 gives 2026-W01 begins 2025-12-29. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Sunday before a new ISO year. 2027-01-03. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2026-12-28 is 2026-W53 gives 2026-W53 begins 2026-12-28. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
- Middle of an ISO week-year. 2026-07-15. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
Check the result
Week of 2026-07-13 is 2026-W29 gives 2026-W29 begins 2026-07-13. Count six dates after the Monday to find the Sunday end. Retain the ISO year with the week number when the report spans New Year.
Troubleshooting and checks
How can a December date belong to the next ISO year?
When January 4 is later in the same Monday-to-Sunday week, that week belongs to the next ISO year. The year on the full calendar date is still unchanged. Store both the dated record and the complete week label if you group data this way.
What formula returns the ISO week-year in a spreadsheet?
With a date in A2, use =YEAR(A2-WEEKDAY(A2,2)+4) to identify the year of that week’s Thursday. Use =ISOWEEKNUM(A2) for the week number. The Thursday and the January 4 rule define the same ISO year boundary.
How can you reconstruct Monday from a year and week number?
Find the Monday on or before January 4 of the ISO year, then add seven times the week number minus one. Verify the result falls before next year’s first ISO Monday. A year with 52 weeks has no valid week 53.