=HOLIDAYNAME("2026-07-03","US")
=HOLIDAYNAME("2026-07-03","US")Returns "Independence Day (observed)".
Formula reference
HOLIDAYNAME
Return the holiday name for a date.
Signature
HOLIDAYNAME(date, country, [subdivision])Square brackets mark optional arguments; do not type the brackets in your formula.
Arguments
| Argument | Meaning |
|---|---|
date | Required. A Sheets date/datetime, YYYY-MM-DD text, or a column of dates. Datetimes are truncated to the calendar day in the spreadsheet’s timezone. |
country | Required. Case-insensitive ISO-3166-1 alpha-2 country code, such as "US". Use COUNTRIES() for the supported directory. |
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. |
Return value
Returns the holiday name, preserving the source’s exact " (estimated)" suffix where supplied. A date without a listed holiday returns "" (empty text), not an error. Known names remain available for incomplete calendar years.
Worked examples
=HOLIDAYNAME("2026-07-06","US")
=HOLIDAYNAME("2026-07-06","US")Returns "" (empty text).
=HOLIDAYNAME(A2:A3,"US")
=HOLIDAYNAME(A2:A3,"US")With A2=2026-07-03 and A3 blank, returns the observed holiday name followed by a blank result.
Dates and range inputs
Use a single date or a column range for the date/start argument. A column returns one result per row; blank cells yield blank results. A range runs in one Apps Script execution for that formula cell. If a nonblank row hits a documented error, the entire formula spill fails.
Dates are date-only in the spreadsheet’s timezone. Text YYYY-MM-DD is accepted. Date outputs are real Dates: apply a date format in Sheets if a serial number appears. Examples use comma separators; some spreadsheet locales require semicolons.
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.