=HOLIDAYS("US",2026)
=HOLIDAYS("US",2026)Returns the known date/name table, beginning 2026-01-01 · New Year's Day.
Country guide · US
United States holidays and business days
Use "US" for the United States country-level calendar. The following coverage describes the pinned release 2026-09-15-holidays-0.104-t0-repair-5.
Weekend rule
Saturday–Sunday, using the Monday-to-Sunday mask 0000011 throughout 2000–2035 in this release. The optional weekend argument overrides the default; extra closures and public holidays still take precedence.
Coverage is statutory weekend only: this code has no source working-weekend data. We do not infer make-up working days or employer-specific schedules.
Subdivision support
States and territories are available on Pro. National completeness does not guarantee regional completeness: US-CA has no complete calendar after 2025 in this release, even though it has no displayed estimated-date suffix.
57 subdivision entries. =SUBDIVISIONS("US") lists the supported suffixes and names on either plan. Using a regional calendar requires Pro.
View all 57 subdivision codes
| Suffix | Name |
|---|---|
AK | Alaska |
AL | Alabama |
AR | Arkansas |
AS | American Samoa |
AZ | Arizona |
CA | California |
CO | Colorado |
CT | Connecticut |
DC | District of Columbia |
DE | Delaware |
FL | Florida |
GA | Georgia |
GU | Guam |
HI | Hawaii |
IA | Iowa |
ID | Idaho |
IL | Illinois |
IN | Indiana |
KS | Kansas |
KY | Kentucky |
LA | Louisiana |
MA | Massachusetts |
MD | Maryland |
ME | Maine |
MI | Michigan |
MN | Minnesota |
MO | Missouri |
MP | Northern Mariana Islands |
MS | Mississippi |
MT | Montana |
NC | North Carolina |
ND | North Dakota |
NE | Nebraska |
NH | New Hampshire |
NJ | New Jersey |
NM | New Mexico |
NV | Nevada |
NY | New York |
OH | Ohio |
OK | Oklahoma |
OR | Oregon |
PA | Pennsylvania |
PR | Puerto Rico |
RI | Rhode Island |
SC | South Carolina |
SD | South Dakota |
TN | Tennessee |
TX | Texas |
UM | United States Minor Outlying Islands |
UT | Utah |
VA | Virginia |
VI | Virgin Islands, U.S. |
VT | Vermont |
WA | Washington |
WI | Wisconsin |
WV | West Virginia |
WY | Wyoming |
Complete years and estimated dates
The national calendar has complete years 2000–2035 in the pinned audit. Each subdivision has its own completeness flags; do not infer regional completeness from this national range.
First estimated year: none labelled in 2000–2035 for this national calendar or its listed subdivisions. No label is not proof of confirmation; completeness is checked independently.
Estimated dates can move by a day when authorities confirm them. Holiday names preserve the source’s " (estimated)" suffix where supplied; some source names suppress that label.
Worked examples
=ISHOLIDAY("2026-01-01","US")
=ISHOLIDAY("2026-01-01","US")Returns TRUE for the first listed national public holiday in 2026.
Free and Pro
Free: every formula for the current calendar year and the next one, in the spreadsheet’s timezone; country-level only, no subdivisions and no custom extra ranges. In 2026, that window is 2026–2027.
Pro: $29/year or $4/month; holiday lists: 2000–2035, subject to source coverage; business-day formulas: years with published calendars. Includes subdivisions, custom extra ranges, and priority data corrections. Compare plans and owner-based access.
Calendar coverage and estimated dates
Estimated dates can move by a day when authorities confirm them. HOLIDAYS and HOLIDAYNAME preserve the source’s exact " (estimated)" suffix where supplied. An absent label does not prove that a date is confirmed.
For codes without working-weekend data, coverage is statutory weekend only: public holidays and the configured weekend rule, with no inferred make-up working days. Business-day formulas require a complete calendar for every year touched; Pro does not unlock unpublished calendars. Read the data coverage guide.