{"id":48,"date":"2026-10-08T09:20:00","date_gmt":"2026-10-08T09:20:00","guid":{"rendered":"https:\/\/datecalculators.org\/blog\/?p=48"},"modified":"2026-10-04T16:24:29","modified_gmt":"2026-10-04T16:24:29","slug":"iso-week-numbers-and-date-conversions","status":"publish","type":"post","link":"https:\/\/datecalculators.org\/blog\/iso-week-numbers-and-date-conversions\/","title":{"rendered":"ISO Week Numbers and Date Conversions"},"content":{"rendered":"

TL;DR:<\/strong> ISO-8601 weeks start Monday; week 1 is the week with the year\u2019s first Thursday. Converting dates to week numbers differs from US Sunday-start casual weeks\u2014label which system reports use.<\/p>\n

Why ISO weeks exist<\/h2>\n

Manufacturing, payroll, and EU reporting align on ISO week to avoid \u201cweek 1 is partial January\u201d arguments. A date may belong to ISO year different from calendar year near January boundaries\u2014display both when auditing.<\/p>\n

Monday start vs Sunday start<\/h2>\n

US kitchen calendars often Sunday-first; ISO Monday-first. \u201cWeek of Jan 5\u201d emails should include ISO week number or explicit date range to prevent offshore team misalignment.<\/p>\n

Week 1 rule in practice<\/h2>\n

Early January dates sometimes fall in ISO week 52\/53 of previous ISO year\u2014dashboard filters by ISO year may exclude them unless configured.<\/p>\n

Converting day span to weeks<\/h2>\n

14 days = 2 ISO weeks only if start aligns with Monday boundary; arbitrary 14-day span may straddle partial weeks at both ends\u2014report partial weeks explicitly in analytics.<\/p>\n

Date to week number workflow<\/h2>\n

Use tooling or spreadsheets with ISO.WEEKNUM equivalent; verify Jan-edge samples against authoritative tables when building compliance exports.<\/p>\n

Planning sprints on ISO weeks<\/h2>\n

Two-week sprint starting arbitrary Wednesday ends not on ISO week boundary\u2014Scrum cares about duration; finance may care about ISO Monday alignment for cost centers\u2014document both.<\/p>\n

Year-over-year compares<\/h2>\n

Comparing \u201cISO week 10\u201d YoY aligns retail seasons better than calendar week-of-month when Easter shifts\u2014still validate with between-dates for promo length in days.<\/p>\n

Logistics and manufacturing<\/h2>\n

Production lot labels often encode YYWW\u2014decode week back to date range with ISO rules before promising customer delivery in calendar dates.<\/p>\n

Travel and ISO confusion<\/h2>\n

Flight booked \u201cweek 32\u201d by European partner: convert to date range before hotel booking\u2014casual week language causes wrong check-in.<\/p>\n

When date calculators help<\/h2>\n

Between-dates gives day span; divide by seven for approximate week count when ISO strictness not required\u2014state approximation. For strict ISO, use ISO-aware functions after day verification on datecalculators.org<\/a>.<\/p>\n

One January test annually<\/h2>\n

Each January, pick Jan 1\u20134, write calendar year vs ISO year-week in team wiki\u2014prevents recurring reporting bug tickets.<\/p>\n

Worked example: retail fiscal week<\/h2>\n

Retailer reports \u201cFW 2026-07\u201d ISO week\u2014convert week to Mon\u2013Sun date range before aligning promo end with e-commerce \u201cends Sunday\u201d banner\u2014off-by-one week misaligns inventory pull.<\/p>\n

Manufacturing lot YYWW stamped on box\u2014decode to calendar ship promise for customer service without guessing.<\/p>\n

Partial week at quarter close<\/h2>\n

Quarter ends Mar 31 mid-week; revenue recognition \u201clast ISO week of quarter\u201d needs ISO boundary table, not casual Sunday guess.<\/p>\n

Payroll ISO week reporting<\/h2>\n

Hourly workers paid weekly on ISO week boundaries\u2014timesheet export week number must match finance ISO year near January; off-by-one week mis-pays overtime thresholds in edge weeks.<\/p>\n

Consulting \u201cbillable week 2026-W12\u201d maps to invoice line date range footnote for client approval.<\/p>\n

School district calendars<\/h2>\n

K\u201312 \u201cweek 28 of school year\u201d district-specific, not ISO\u2014do not feed district week into ISO converter; use district PDF date ranges for between-dates instead.<\/p>\n

Retail 4-5-4 calendar<\/h2>\n

Some retailers use 4-5-4 fiscal months\u2014not ISO, not civil month\u2014between civil dates for promos must map via retailer calendar PDF, not ISO week converter alone.<\/p>\n

Inventory \u201cweek of supply\u201d metrics divide stock by daily sales\u2014week count display is derived; source truth remains days of cover at current velocity.<\/p>\n

Broadcast TV seasons<\/h2>\n

TV \u201c22-episode season\u201d week broadcast schedule uses industry weeks, not ISO\u2014use show press release date ranges for between-dates fan planning.<\/p>\n

Government fiscal year vs ISO<\/h2>\n

US federal fiscal year starts Oct 1\u2014between Oct 1 and Sep 30 boundary is not ISO week aligned. Reports citing \u201cFY26 Q2\u201d need agency calendar PDF, not guesswork from civil quarters.<\/p>\n

EU project reporting may require ISO week on grant forms\u2014convert deliverable civil dates to ISO week range footnote before submission PDF export.<\/p>\n

Sports tournaments \u201cweek 2 of group stage\u201d broadcast slang\u2014verify actual civil dates for travel booking, not week label alone.<\/p>\n

Cross-border week reporting<\/h2>\n

Team in US and EU submits \u201cweek 12 report\u201d\u2014require ISO date range subtitle on every weekly slide: \u201c2026-W12 = 2026-03-16 Mon \u2013 2026-03-22 Sun ISO\u201d to kill ambiguity.<\/p>\n

Scrum “velocity per week” is story points not ISO weeks\u2014do not divide sprint points by ISO week number from finance report; different “week” words.<\/p>\n

Podcast “Episode drops every Tuesday” for 12 weeks\u2014add 7 repeatedly twelve times from premiere Tuesday, verify landing dates against between-dates span inclusive of finale week.<\/p>\n

Academic journal “volume issue week” metadata\u2014cite article with full ISO publication date in bibliography even when table of contents groups by issue week label.<\/p>\n

Manufacturing OEE weekly reports tied to plant shift calendar starting Sunday night\u2014ISO week may not match; plant week label on report header must map to civil dates before comparing to corporate ISO dashboard.<\/p>\n

TV ratings “week of” Nielsen definitions differ from ISO\u2014media buyers verify broadcast calendar PDF when reconciling ad flight length in days.<\/p>\n

Wikipedia “week numbering” article lists edge cases\u2014when executive slides disagree with Wikipedia ISO examples, trust formal ISO 8601 text and your calculator spot check, not anecdotal forum posts.<\/p>\n","protected":false},"excerpt":{"rendered":"

ISO weeks start Monday; week 1 contains the first Thursday\u2014special rules differ from casual week counting.<\/p>\n","protected":false},"author":1,"featured_media":12,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-calendar-math"],"_links":{"self":[{"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":4,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions\/140"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/media\/12"}],"wp:attachment":[{"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datecalculators.org\/blog\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}