Collections ยท Included with a Data Pass
Every date from 1900 to 2100, ready to join.
73,414 dates with the parts reports keep asking for: weekday, week number, quarter, fiscal period, U.S. federal holidays and business days. Join it to anything with a date instead of rebuilding a calendar in every project.
- Rows
- 73,414
- Columns
- 31
- Formats
- CSV, JSON, XML
As of: January 1, 1900 to December 31, 2100. Holidays follow federal law as of 2026. Changes only when federal holidays change, as they did when Juneteenth was added in 2021.
Preview
A few real rows
| CalendarDate | DayName | WeekOfYear | Holiday | HolidayObserved | IsBusinessDay | FiscalYear | FiscalQuarter |
|---|---|---|---|---|---|---|---|
| 2026-11-23 | Monday | 48 | Yes | 2027 | 1 | ||
| 2026-11-24 | Tuesday | 48 | Yes | 2027 | 1 | ||
| 2026-11-25 | Wednesday | 48 | Yes | 2027 | 1 | ||
| 2026-11-26 | Thursday | 48 | Thanksgiving Day | Thanksgiving Day | No | 2027 | 1 |
| 2026-11-27 | Friday | 48 | Yes | 2027 | 1 | ||
| 2026-11-28 | Saturday | 48 | No | 2027 | 1 | ||
| 2026-11-29 | Sunday | 49 | No | 2027 | 1 |
Field guide
What's in each row
The date
The date itself, an integer key like 20261126, and its year, quarter, month and day.
CalendarDate DateKey Year Quarter QuarterName Month MonthName MonthAbbreviation DayOfMonth DayOfYear
Weeks
Day of the week (1 is Sunday), U.S. week numbers that start on Sunday, and ISO weeks that start on Monday.
DayOfWeek DayName DayAbbreviation IsWeekend WeekOfYear ISOWeek ISOYear
Holidays and work days
The holiday on its actual date, the holiday on the day it is observed, and whether the day is a business day.
Holiday HolidayObserved IsBusinessDay BusinessDayOfMonth IsLastBusinessDayOfMonth
Month and fiscal year
First and last day of the month, days in the month, leap years, and the federal fiscal year that starts October 1.
FirstDayOfMonth LastDayOfMonth DaysInMonth IsLastDayOfMonth IsLeapYear FiscalYear FiscalQuarter FiscalMonth
Good to know
Before you use it
- Holidays appear in the years they existed: Martin Luther King Jr. Day from 1986, Juneteenth from 2021, and the Monday holidays from 1971.
- Observed days use today's rule for every year: a Saturday holiday is observed on Friday, a Sunday holiday on Monday.
- In every format, dates are written as yyyy-MM-dd, and yes/no values as true or false. An empty value means nothing was recorded.
Source
Generated by MySafeInfo from the federal holiday law, 5 U.S.C. 6103
Free to use with your pass
Where it comes in handy
What people build with it
- Reports and dashboards. Use it as the date table in Power BI, Excel or a data warehouse.
- Business-day math. Find the third business day of a month or the next working day after a holiday.
- Fiscal reporting. Group by the federal fiscal year, which starts October 1.
- Scheduling. Skip weekends and holidays when you set due dates or delivery windows.
Access
Try it free. Get all of it with a pass.
Free sample
- Every day of 2026
- A README with the field guide and source
Data Pass $39
- All 73,414 rows of Calendar table
- One ZIP in CSV, JSON or XML, with a README
- Also every other collection and the whole dataset catalog, for 365 days
Already have a pass?
Your key is used for this request and is not saved by this page.
Using it in a product or service for others? That needs a Commercial Pass.