Plainfold calendar reference

ISO week numbers 2025

ISO 8601 week numbers for 2025. ISO year 2025 has 52 weeks, from Monday, December 30, 2024 to Sunday, December 28, 2025. 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).

December 31, 2025 is in week 1 of ISO year 2026.

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

Get the ISO week of a date in code:

Python      date(2025, 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