=ISHOLIDAY("2026-07-03","US")
=ISHOLIDAY("2026-07-03","US")TRUE: Independence Day is observed on this Friday.
Formula reference
ISHOLIDAY
Check whether a date is a public holiday.
Signature
ISHOLIDAY(date, country, [subdivision], [extra])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. |
extra | Optional, Pro. A real range of additional non-working dates, for example H2:H10. Blank cells are ignored. Changing the range recalculates the formula. Extra dates win over holidays, working-weekend exceptions and weekend rules. |
Return value
Returns TRUE if the date is a public holiday or appears in extra; otherwise FALSE. A weekend alone is not a public holiday. A FALSE result means the date is not in the available holiday list; it does not certify an incomplete calendar.
Worked examples
=ISHOLIDAY(A2:A4,"US")
=ISHOLIDAY(A2:A4,"US")With A2=2026-07-03, A3 blank and A4=2026-07-06, the results are TRUE, blank, FALSE.
=ISHOLIDAY("2026-07-06","US","",H2:H3)
=ISHOLIDAY("2026-07-06","US","",H2:H3)Pro: TRUE when H2 contains the date 2026-07-06 and H3 is blank. Your extra closure is included.
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)
#N/A Custom holiday ranges 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.