Week number guides
Clear, tested explanations of week numbers: the ISO 8601 rules, how ISO and US numbering differ, how to calculate week numbers in spreadsheets and code, and full week tables. Every page shows when it was last updated, and lists and tables are generated by code rather than typed by hand.
Guides
In-depth explanations of how week numbers work and how to calculate them.
What is ISO 8601 week numbering?
The rules behind “week 1”, why weeks cross New Year, the 2026-W43-5 notation and the mistakes that break week-number code.
ISO vs US week numbers, and other week systems
A side-by-side comparison of ISO, US, “week 0” and Saturday-start numbering, with the Excel return types and a table of dates where they disagree.
How to get the week number in Excel, Python, JavaScript, SQL and PHP
Copy-ready formulas and snippets, each shown with its result for January 1, 2027 (ISO 2026-W53), plus the format-code traps to avoid.
Which years have 53 weeks?
The rule for 53-week years, a generated list from 1900 to 2100 with the dates of each week 53, and the US-system week 54.
Reference tables and FAQ
Generated week tables and quick answers.
Week numbers for 2026
All 53 weeks of 2026 with start and end dates, US week numbers and federal holidays.
Week numbers for 2027
All 52 weeks of 2027, why January 1–3 are in week 53 of 2026, US week numbers and federal holidays.
Week number FAQ
Quick, checked answers: how many weeks 2026 has, when 2027’s week 1 starts, what “KW” means, working days per year and more.
Tools and week pages
Interactive tools and generated pages that go with the guides.
Week number lookup
Any date to its ISO and US week, day of year, days remaining and quarter, or any week to its dates in both systems.
Week pages for 2026 and 2027
A page for every week with its dates, US week numbers and holidays in Canada, the US, Mexico, Japan and Taiwan.
Calendar export: PDF and .ics
Print a one-page year calendar or add week numbers to Google Calendar, Outlook or Apple Calendar.
How we write these guides
Each guide is written and maintained by Week Number Now, a site run by LCD3L. Dates and examples are checked with code, and code snippets are run where we have the software to run them; each guide says what was verified and how. We update guides when standards, software or holiday rules change, and when readers report mistakes. Suggestions for new guides are welcome at hello@weekcheck.net.