United States
US · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Holiday Formulas for Google Sheets™
Find your country’s calendar
The pinned index contains 251 country entries, including the source’s UK alias. Use COUNTRIES() for the full directory and SUBDIVISIONS(country) for regional suffixes. These ten guides explain the data available for common country codes.
United Kingdom
GB · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Germany
DE · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
France
FR · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Israel
IL · Friday–Saturday weekend
National complete years: 2000–2035. Regional completeness is separate.
India
IN · Saturday–Sunday weekend
No complete year under the current source. Holiday lists remain available.
Australia
AU · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Canada
CA · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Brazil
BR · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
Japan
JP · Saturday–Sunday weekend
National complete years: 2000–2035. Regional completeness is separate.
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.