ISO week numbers 2027
ISO 8601 week numbers for 2027. ISO year 2027 has 52 weeks, from Monday, January 4, 2027 to Sunday, January 2, 2028. Weeks start on Monday, and week 1 is the week that contains the first Thursday of the year (the same week that contains January 4).
January 1, 2027 is in week 53 of ISO year 2026.
| Week | Monday | Sunday |
|---|---|---|
| 1 | January 4, 2027 | January 10, 2027 |
| 2 | January 11, 2027 | January 17, 2027 |
| 3 | January 18, 2027 | January 24, 2027 |
| 4 | January 25, 2027 | January 31, 2027 |
| 5 | February 1, 2027 | February 7, 2027 |
| 6 | February 8, 2027 | February 14, 2027 |
| 7 | February 15, 2027 | February 21, 2027 |
| 8 | February 22, 2027 | February 28, 2027 |
| 9 | March 1, 2027 | March 7, 2027 |
| 10 | March 8, 2027 | March 14, 2027 |
| 11 | March 15, 2027 | March 21, 2027 |
| 12 | March 22, 2027 | March 28, 2027 |
| 13 | March 29, 2027 | April 4, 2027 |
| 14 | April 5, 2027 | April 11, 2027 |
| 15 | April 12, 2027 | April 18, 2027 |
| 16 | April 19, 2027 | April 25, 2027 |
| 17 | April 26, 2027 | May 2, 2027 |
| 18 | May 3, 2027 | May 9, 2027 |
| 19 | May 10, 2027 | May 16, 2027 |
| 20 | May 17, 2027 | May 23, 2027 |
| 21 | May 24, 2027 | May 30, 2027 |
| 22 | May 31, 2027 | June 6, 2027 |
| 23 | June 7, 2027 | June 13, 2027 |
| 24 | June 14, 2027 | June 20, 2027 |
| 25 | June 21, 2027 | June 27, 2027 |
| 26 | June 28, 2027 | July 4, 2027 |
| 27 | July 5, 2027 | July 11, 2027 |
| 28 | July 12, 2027 | July 18, 2027 |
| 29 | July 19, 2027 | July 25, 2027 |
| 30 | July 26, 2027 | August 1, 2027 |
| 31 | August 2, 2027 | August 8, 2027 |
| 32 | August 9, 2027 | August 15, 2027 |
| 33 | August 16, 2027 | August 22, 2027 |
| 34 | August 23, 2027 | August 29, 2027 |
| 35 | August 30, 2027 | September 5, 2027 |
| 36 | September 6, 2027 | September 12, 2027 |
| 37 | September 13, 2027 | September 19, 2027 |
| 38 | September 20, 2027 | September 26, 2027 |
| 39 | September 27, 2027 | October 3, 2027 |
| 40 | October 4, 2027 | October 10, 2027 |
| 41 | October 11, 2027 | October 17, 2027 |
| 42 | October 18, 2027 | October 24, 2027 |
| 43 | October 25, 2027 | October 31, 2027 |
| 44 | November 1, 2027 | November 7, 2027 |
| 45 | November 8, 2027 | November 14, 2027 |
| 46 | November 15, 2027 | November 21, 2027 |
| 47 | November 22, 2027 | November 28, 2027 |
| 48 | November 29, 2027 | December 5, 2027 |
| 49 | December 6, 2027 | December 12, 2027 |
| 50 | December 13, 2027 | December 19, 2027 |
| 51 | December 20, 2027 | December 26, 2027 |
| 52 | December 27, 2027 | January 2, 2028 |
Get the ISO week of a date in code:
Python date(2027, 3, 15).isocalendar().week
PostgreSQL extract(week from d), extract(isoyear from d)
SQL Server DATEPART(iso_week, d)
MySQL WEEK(d, 3), YEARWEEK(d, 3)
Excel =ISOWEEKNUM(A1)Use the ISO year, not the calendar year, next to the week number: dates near January 1 can belong to the previous or next ISO year. US-style week numbers (weeks starting Sunday, week 1 = the week of January 1, as in Excel's default WEEKNUM) can differ by one week.
Computed with the ISO 8601 rule and checked against Python's isocalendar() and the C library %G-%V format. A date dimension needs both ISO and US week columns; the pack below has both.
Other years: 2025 · 2026 · 2027 · 2028 · 2029 · 2030 · 2031
Free: pip install retailcal generates any 4-4-5 / 4-5-4 / 5-4-4 calendar as CSV; source at github.com/plainfoldhq/date-dimension.
Date dimension pack ($19): a 45-column dim_date 2000-2050 with holiday, NYSE and fiscal columns, 4 precomputed fiscal calendars, SQLite, a tested PostgreSQL loader and a dbt seed config. Get the pack
All three data packs (business days, date dimension, time zones): $35. Bundle