Holiday Formulas for Google Sheets™
Your due date.
Your country’s calendar.
Calculate public holidays and working days in Google Sheets, with country calendars built into your formulas.
Plan an SLA, delivery date or team schedule without maintaining another holiday list.
Installation and checkout will be available after launch review.
=WORKDAY_CTRY("2026-07-02",2,"US")| Date | Calendar day |
|---|---|
| 2 July | Start · Thursday |
| 3 July | Observed holiday |
| 4–5 July | Weekend |
| 6 July | Business day 1 |
| 7 July | Due · business day 2 |
Holiday lists
Use HOLIDAYS and HOLIDAYNAME for sorted dates and the source’s holiday names.
List holidaysBusiness days
Count working days with NETWORKDAYS_CTRY or move a due date with WORKDAY_CTRY.
Count business daysCountry and region
The index contains 251 country entries. Pro adds the source’s regional calendars.
Explore country coverageFree to start. Pro for a wider calendar.
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.
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.