Compare week systems
The same calendar date can have different week numbers depending on which convention is used.
Convert any date to ISO 8601 or other week numbering, reverse a week number back to its seven dates, compare systems side by side, inspect year-boundary surprises, navigate every week of a year and export a complete week table.
—
The same calendar date can have different week numbers depending on which convention is used.
Use the same convention in your spreadsheet so reports and dashboards agree with the calculator.
=ISOWEEKNUM(A1)=WEEKNUM(A1,21)=WEEKNUM(A1,1)=WEEKNUM(A1,2)Every numbered week under the selected system, including dates that cross calendar-year boundaries.
| Week | Start | End | Crosses year? | Action |
|---|
ISO 8601 starts weeks on Monday and requires week 1 to contain at least four days of the new year. A Sunday-start/Jan-1 system starts weeks on Sunday and makes the week containing January 1 week 1. Monday/Jan-1 keeps Monday starts but still assigns January 1 to week 1.
Custom mode lets you choose the first weekday and the minimum number of new-year days required in week 1—useful for matching a specific organization or software configuration.
Dates around New Year are where week-number bugs usually hide. This calculator keeps the week-year separate from the ordinary calendar year, shows the exact seven-day range and flags when the selected week crosses into another calendar year.
The full table also exposes whether the selected week-year has 52 or 53 numbered weeks.