HOLIDAYS
List public holidays by country and year.
Holiday Formulas for Google Sheets™
A country calendar in every formula
Choose a country code, supply dates, and calculate holidays, business days or a due date in Google Sheets. All eleven functions are available on Free within its country-level current + next calendar-year window.
ISHOLIDAY
Check whether a date is a public holiday.
HOLIDAYNAME
Return the holiday name for a date.
ISWORKDAY
Check whether a date is a business day.
NETWORKDAYS_CTRY
Count business days between two dates by country.
WORKDAY_CTRY
Calculate a due date by adding business days.
NEXTWORKDAY
Find the first business day strictly after a date.
PREVWORKDAY
Find the first business day strictly before a date.
COUNTRIES
List supported country codes and names.
SUBDIVISIONS
Find region codes for a country.
HF_VERSION
Show the data release and licence status.
Start with a real date
Use a date cell or quoted YYYY-MM-DD text. Datetimes are truncated to the calendar day in the spreadsheet’s timezone. Date outputs are real Dates, ready for date formatting. Seven date/start functions accept column ranges, with blanks preserved.
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.