Plainfold calendar reference

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.

WeekMondaySunday
1January 4, 2027January 10, 2027
2January 11, 2027January 17, 2027
3January 18, 2027January 24, 2027
4January 25, 2027January 31, 2027
5February 1, 2027February 7, 2027
6February 8, 2027February 14, 2027
7February 15, 2027February 21, 2027
8February 22, 2027February 28, 2027
9March 1, 2027March 7, 2027
10March 8, 2027March 14, 2027
11March 15, 2027March 21, 2027
12March 22, 2027March 28, 2027
13March 29, 2027April 4, 2027
14April 5, 2027April 11, 2027
15April 12, 2027April 18, 2027
16April 19, 2027April 25, 2027
17April 26, 2027May 2, 2027
18May 3, 2027May 9, 2027
19May 10, 2027May 16, 2027
20May 17, 2027May 23, 2027
21May 24, 2027May 30, 2027
22May 31, 2027June 6, 2027
23June 7, 2027June 13, 2027
24June 14, 2027June 20, 2027
25June 21, 2027June 27, 2027
26June 28, 2027July 4, 2027
27July 5, 2027July 11, 2027
28July 12, 2027July 18, 2027
29July 19, 2027July 25, 2027
30July 26, 2027August 1, 2027
31August 2, 2027August 8, 2027
32August 9, 2027August 15, 2027
33August 16, 2027August 22, 2027
34August 23, 2027August 29, 2027
35August 30, 2027September 5, 2027
36September 6, 2027September 12, 2027
37September 13, 2027September 19, 2027
38September 20, 2027September 26, 2027
39September 27, 2027October 3, 2027
40October 4, 2027October 10, 2027
41October 11, 2027October 17, 2027
42October 18, 2027October 24, 2027
43October 25, 2027October 31, 2027
44November 1, 2027November 7, 2027
45November 8, 2027November 14, 2027
46November 15, 2027November 21, 2027
47November 22, 2027November 28, 2027
48November 29, 2027December 5, 2027
49December 6, 2027December 12, 2027
50December 13, 2027December 19, 2027
51December 20, 2027December 26, 2027
52December 27, 2027January 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