1. Two Incompatible Definitions of "Week 1"
Cross-border supply chains, ERP manufacturing schedules, and BI dashboards routinely break in late December and early January because European/global logistics teams use ISO-8601 week dates while US spreadsheets and consumer calendars default to North American Sunday-start week numbers. You can check any date instantly in our live Week Number Calculator.
ISO-8601 Standard (ISO 8601-1:2019)
Every week is an unbroken 7-day block running Monday (Day 1) through Sunday (Day 7). W01 of an ISO week-numbering year is defined by three mathematically identical rules: (1) the week containing the year's first Thursday, (2) the week containing January 4, and (3) the first week with at least 4 days (≥4) in the new calendar year. Consequently, an ISO year always spans either 52 full weeks (364 days) or 53 full weeks (371 days)—never partial stub weeks.
US / Spreadsheet Standard (Sunday–Saturday)
Weeks run Sunday through Saturday, and Week 1 begins unconditionally on January 1—even when January 1 is a Friday or Saturday! Week 2 then begins on the very first Sunday of January. Because 365 days exceed 52 weeks (364 days), the US system splits the boundary week into two partial stubs: a short Week 53 ending December 31 (1–6 days) and a short Week 1 starting January 1 (1–6 days) in almost every single year.
2. Worked Year-Boundary Table: Dec 2025 – Jan 2026 – Dec 2026 – Jan 2027
The 2026–2027 cycle illustrates both boundary anomalies in action. Because 2026 starts on Thursday, January 1, 2026 and ends on Thursday, December 31, 2026, it contains 53 Thursdays and is therefore an official 53-week ISO year (compare full schedules on Week Numbers 2026 and Week Numbers 2027). Notice what happens on Sunday, January 3, 2027 in the table below: an ISO system labels that single day 2026-W53, while a US Sunday-start spreadsheet labels the exact same day 2027 Week 2—disagreeing on both the year and the week number!
| Calendar Date Range | Weekdays | ISO-8601 Week | US Week (Sun Start) | Why They Diverge |
|---|---|---|---|---|
| Dec 22 – Dec 27, 2025 | Mon – Sat (6d) | 2025-W52 | 2025 Week 52 | Both systems align Mon–Sat |
| Dec 28, 2025 | Sunday (1d) | 2025-W52 | 2025 Week 53 | Sunday opens a 4-day US stub week (Dec 28–31) |
| Dec 29 – Dec 31, 2025 | Mon – Wed (3d) | 2026-W01 | 2025 Week 53 | 1st Thursday is Jan 1, pulling Dec 29–31 into ISO 2026-W01 |
| Jan 1 – Jan 3, 2026 | Thu – Sat (3d) | 2026-W01 | 2026 Week 1 | US Week 1 is a 3-day partial stub (Jan 1–3) |
| Jan 4, 2026 | Sunday (1d) | 2026-W01 | 2026 Week 2 | Day 7 of ISO W01, but first Sunday starts US Week 2 |
| Dec 27, 2026 | Sunday (1d) | 2026-W52 | 2026 Week 53 | ISO W52 ends Sunday; US opens 5-day Week 53 |
| Dec 28 – Dec 31, 2026 | Mon – Thu (4d) | 2026-W53 | 2026 Week 53 | 53rd Thursday (Dec 31) creates full ISO Week 53 |
| Jan 1 – Jan 2, 2027 | Fri – Sat (2d) | 2026-W53 | 2027 Week 1 | Only 3 days in 2027; Jan 1–2 remain in ISO year 2026! |
| Jan 3, 2027 | Sunday (1d) | 2026-W53 | 2027 Week 2 | Maximum collision: 2026-W53 vs. 2027-W02 on same date! |
| Jan 4 – Jan 9, 2027 | Mon – Sat (6d) | 2027-W01 | 2027 Week 2 | ISO 2027-W01 starts Monday Jan 4 (contains Thu Jan 7) |
3. SQL, Excel, Python & JavaScript Implementation Cheat Sheet
The single deadliest reporting bug in business intelligence occurs when engineers concatenate a Gregorian calendar year (YYYY or %Y) with an ISO week number (IW or %V). On Friday, January 1, 2027, formatting YYYY-IW outputs 2027-53—sorting early-January revenue at the end of 2027! Always extract the dedicated ISO week-numbering year alongside the ISO week:
| Platform / Language | ISO-8601 (Year + Week) | US Sunday-Start Week | Critical Pitfall to Avoid |
|---|---|---|---|
| Excel / Google Sheets | =ISOWEEKNUM(A2) | =WEEKNUM(A2, 1) | WEEKNUM(A2, 2) starts Monday on Jan 1 (NOT ISO!)—use return type 21 or ISOWEEKNUM |
| PostgreSQL | TO_CHAR(d, 'IYYY-"W"IW') | EXTRACT(YEAR FROM d) + Sunday offset | Never combine Gregorian YYYY with ISO IW; always use IYYY or EXTRACT(ISOYEAR FROM d) |
| MySQL / MariaDB | YEARWEEK(d, 3) | WEEK(d, 0) + 1 (or mode 2) | Default WEEK(d) uses server default_week_format (usually 0, returning 0–53) |
| BigQuery / Snowflake | EXTRACT(ISOYEAR), EXTRACT(ISOWEEK) | EXTRACT(WEEK(SUNDAY) FROM d) | In Snowflake, session parameter WEEK_OF_YEAR_POLICY alters WEEK() unless WEEKISO() is used |
| Python (stdlib) | d.strftime('%G-W%V') / d.isocalendar() | int(d.strftime('%U')) (0-based pre-Sun) | Use %G (ISO year) with %V—never %Y-W%V |
| JavaScript / TypeScript | Temporal.PlainDate (.yearOfWeek / .weekOfYear) | UTC day-of-year + Jan 1 getUTCDay() | Compute legacy Date math in UTC to prevent spring-forward DST 23-hour day rounding bugs |
4. NRF 4-4-5 / 4-5-4 Retail Accounting & US Broadcast Calendars
Beyond ISO-8601 and standard US calendar weeks, two specialized American industry calendars govern retail merchandising and media buying:
- National Retail Federation (NRF) 4-5-4 & Corporate 4-4-5 Calendars: Comparing Gregorian May 2026 (5 Saturdays, 5 Sundays) against May 2025 (5 Saturdays, 4 Sundays) distorts weekend-heavy retail comps. To eliminate weekday mix shifts, the NRF 4-5-4 standard structures a 364-day fiscal year (usually beginning the Sunday closest to February 1) into four 13-week quarters subdivided into 4-week (28-day), 5-week (35-day), and 4-week (28-day) fiscal months running Sunday through Saturday. Every fiscal month contains the exact same count of Saturdays and Sundays year over year, and every 5 to 6 years the NRF inserts a 53rd retail week in Fiscal January to realign with the solar calendar.
- US Broadcast Television & Radio Calendar: Standardized for Nielsen ratings and ad-spot billing, Broadcast Weeks run Monday through Sunday (matching ISO-8601's weekday span), except that Broadcast Week 1 is strictly defined as the Monday–Sunday week containing January 1—meaning Broadcast 2027 Week 1 begins on Monday, December 28, 2026 (
2026-W53in ISO-8601!). Always verify whether media contracts specify ISO or Broadcast week dates against full 2026 and 2027 reference grids.
Look Up Any ISO or US Week Number Instantly
Convert specific dates or browse complete 53-week 2026 and 52-week 2027 schedules side by side.