=HOLIDAYS("US",2026)
=HOLIDAYS("US",2026)A two-column table beginning 2026-01-01 · New Year’s Day, then 2026-01-19 · Martin Luther King Jr. Day.
Formula reference
HOLIDAYS
List public holidays by country and year.
Signature
HOLIDAYS(country, year, [subdivision], [names])Square brackets mark optional arguments; do not type the brackets in your formula.
Arguments
| Argument | Meaning |
|---|---|
country | Required. Case-insensitive ISO-3166-1 alpha-2 country code, such as "US". Use COUNTRIES() for the supported directory. |
year | Required. Four-digit calendar year. Free: current + next calendar year in the spreadsheet’s timezone. Pro: 2000–2035, subject to source coverage. |
subdivision | Optional, Pro for calendar calculations. ISO-3166-2 suffix as listed by SUBDIVISIONS(country), such as "BY" for Bavaria. Omit or use "" for the national calendar. Use source-specific suffixes exactly as listed. |
names | Optional. TRUE by default: returns dates and names. FALSE: returns one column of dates. |
Return value
Returns a 2-D table sorted by date ascending: column A contains real Dates, and column B contains holiday names when names=TRUE (the default). With names=FALSE, returns only the date column. Estimated dates carry the exact " (estimated)" suffix supplied by the data source.
Worked examples
=HOLIDAYS("DE",2026,"BY",FALSE)
=HOLIDAYS("DE",2026,"BY",FALSE)Pro: one date column for Bavaria, beginning 2026-01-01, 2026-01-06, and 2026-04-03.
=HOLIDAYS("IN",2026)
=HOLIDAYS("IN",2026)Known holiday dates and names, beginning 2026-01-26 · Republic Day. This list remains available even though India has no complete year for business-day calculations.
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.
Errors
Errors are explicit. The examples below retain the exact specification text:
#N/A Unknown code XX; see COUNTRIES()— replace XX with the requested code.#N/A No holiday data for XX in 2036— a calculation touched a year with no data. Missing data is never treated as “no holidays”.#N/A Year 2028 needs Holiday Formulas Pro (holidayformulas.com/pro)— example for a Free user in 2026. The year in the message is the requested out-of-window year. View Pro.
#N/A Regional calendars (US-CA) need Holiday Formulas Pro (holidayformulas.com/pro)
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.