How to Find an ISO Week Number and Its Start Date

All guides › Calendars

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.

Days Between Dates Calculator

Step by step

  1. Find the Monday of the week containing January 4 for the ISO year you want.
  2. Add seven days for each week after week 1. For week 10, add nine weeks. The week ends six days after that Monday.
  3. 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.

Worked examples and expected results
ScenarioInputsCalculationResult
New Year in the preceding ISO week-year2021-01-01Week of 2020-12-28 is 2020-W532020-W53 begins 2020-12-28
First Monday of a new ISO year2021-01-04Week of 2021-01-04 is 2021-W012021-W01 begins 2021-01-04
December already in week one2025-12-29Week of 2025-12-29 is 2026-W012026-W01 begins 2025-12-29
Start of a year on Thursday2026-01-01Week of 2025-12-29 is 2026-W012026-W01 begins 2025-12-29
Sunday before a new ISO year2027-01-03Week of 2026-12-28 is 2026-W532026-W53 begins 2026-12-28
Middle of an ISO week-year2026-07-15Week of 2026-07-13 is 2026-W292026-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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Sources

Calculation methodology · Report an error