ReckonDay

Blog

ISO-8601 Week Numbers Explained: Why Week 1 Isn't Always the First Week

The problem week numbers are solving

"What week of the year is it" sounds like it should have an obvious, universal answer: divide the day-of-year number by 7 and round. In practice, there are at least two genuinely different, both-legitimate systems in wide use, and they don't agree with each other near the start and end of the year — which is exactly where most of the confusion (and most real scheduling mistakes) actually happen.

The ISO-8601 system

ISO-8601 — the international standard behind most of the date and time formatting conventions used in software, shipping, and international business — defines week numbers with two specific rules. First, weeks run Monday through Sunday, not Sunday through Saturday. Second, and more importantly, week 1 of any year is defined as the week containing that year's first Thursday, which is mathematically equivalent to saying it's the week containing January 4th.

That second rule is the one that produces the counterintuitive results. Since week 1 is anchored to January 4th rather than to January 1st itself, the first few days of January can actually belong to the LAST week of the previous year, not the first week of the new one — specifically whenever January 1st falls on a Friday, Saturday, or Sunday. Symmetrically, the last few days of December can belong to week 1 of the FOLLOWING year, whenever December 31st falls on a Monday, Tuesday, or Wednesday.

A worked example of the year-boundary case

Take January 1, 2027, which falls on a Friday. Under the ISO-8601 rule, week 1 of 2027 is the week containing January 4, 2027 (a Monday), which runs from that Monday through Sunday, January 10th. That means January 1st, 2nd, and 3rd, 2027 — Friday, Saturday, and Sunday — actually belong to the LAST ISO week of 2026, not the first week of 2027, even though they fall in January of the new year on the calendar. Whether that last week of 2026 is numbered week 52 or week 53 depends on whether 2026 is a "long" ISO year (see below) — and 2026 happens to be exactly that kind of year, since its January 1st falls on a Thursday.

Why some years get a 53rd week

A regular year has 365 days, which is 52 weeks plus 1 extra day; a leap year has 366 days, 52 weeks plus 2 extra days. Those leftover 1 or 2 days are exactly why a year needs an extra, 53rd ISO week in some cases: if the leftover day (or one of the two leftover days, in a leap year) happens to be a Thursday, there are effectively 53 distinct Thursdays across that calendar year, which under the ISO rule (week 1 is defined by its Thursday) means there are 53 distinct weeks needing their own number.

The precise condition: a year has 53 ISO weeks if January 1st falls on a Thursday, OR if the year is a leap year and January 1st falls on a Wednesday. This happens on roughly 71 years out of every 400-year Gregorian cycle — call it roughly once every 5 to 6 years on average, though the exact spacing isn't perfectly even because it's tied to the same leap-year distribution pattern that governs the whole calendar's weekday cycle.

The US-style alternative system

A separate, simpler convention — sometimes just called the "US" or "simple" week-numbering system, and used by default in several spreadsheet functions — instead anchors week 1 to January 1st directly and runs weeks Sunday through Saturday. Under this system, January 1st is always in week 1, no matter what weekday it falls on, and there's no year-boundary ambiguity the way there is under ISO-8601.

The tradeoff: this simpler system can produce a "week 1" that's only 1, 2, or a few days long if January 1st falls late in what would otherwise be a full week, and it doesn't have the same clean mathematical property of always producing a consistent 52-or-53-week total the way ISO-8601 does. Neither system is objectively more correct — they're solving the same basic problem with different design priorities, and the practical issue is simply that mixing the two without realizing it produces mismatched week numbers for the same date.

Where this causes real problems

Microsoft Excel's WEEKNUM function is the single most common real place this mismatch shows up: by default, WEEKNUM uses the simpler Sunday-start, January-1-anchored system, not ISO-8601, unless you explicitly pass the argument that switches it to ISO mode (return_type 21, if you're checking). Someone comparing a week number generated by Excel's default behavior against one generated by an ISO-8601-compliant system (or against this site's Week Number Calculator, which defaults to ISO-8601) can get genuinely different numbers for the same date, particularly near the start or end of the year — and neither number is "wrong," they're just answering under different conventions.

Manufacturing schedules, shipping and logistics systems, and some payroll cycles also reference week numbers directly rather than calendar dates, and a mismatch between which system generated a given "week 12" reference and which system is reading it back can mean two systems are quietly talking about two different 7-day spans without anyone noticing until a shipment or a paycheck is off by a week.

The practical rule of thumb

If you're working with week numbers in any professional or technical context, the safest habit is to state explicitly which system is in use — ISO-8601 or the simpler Sunday-start alternative — anywhere the week number is recorded, rather than assuming it's obvious. The Week Number Calculator on this site defaults to ISO-8601 (the international standard, and the one most software and business contexts expect unless stated otherwise) but supports the US-style alternative specifically because both are genuinely in active, legitimate use.

Tools mentioned in this post