=WORKDAY_CTRY("2026-07-02",2,"US")
=WORKDAY_CTRY("2026-07-02",2,"US")Returns the date 2026-07-07: Friday is an observed holiday, followed by the weekend.
Formula reference
WORKDAY_CTRY
Calculate a due date by adding business days.
Signature
WORKDAY_CTRY(start, days, country, [subdivision], [weekend], [extra])Square brackets mark optional arguments; do not type the brackets in your formula.
Arguments
| Argument | Meaning |
|---|---|
start | Required. A Sheets date/datetime, YYYY-MM-DD text, or a column of start dates. Datetimes are truncated to the calendar day in the spreadsheet’s timezone. |
days | Required. Number of business days to move; positive moves forward, negative backward. Zero returns the start date unchanged. Fractional values are truncated toward zero. |
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. |
weekend | Optional. Defaults to the country’s effective-dated weekend rule. Accepts NETWORKDAYS.INTL codes 1–7 or 11–17, or a quoted seven-character mask, Monday to Sunday (1 = non-working): "0000011" means Saturday–Sunday. Make-up working days still override the weekend rule. |
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 a real Date days business days after start. Negative days move backwards. days=0 returns start unchanged, even when start is a weekend or holiday, as WORKDAY does. Every year touched must have data and be within the owner’s tier; business-day calculations require published calendars.
Worked examples
=WORKDAY_CTRY("2026-07-06",-1,"US")
=WORKDAY_CTRY("2026-07-06",-1,"US")Returns the date 2026-07-02, moving backward over the holiday and weekend.
=WORKDAY_CTRY("2026-07-04",0,"US")
=WORKDAY_CTRY("2026-07-04",0,"US")Returns the date 2026-07-04 unchanged, although it is a Saturday and holiday.
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 Calendar for CN 2027 not yet published; HOLIDAYS() shows the confirmed dates
This error applies to an incomplete calendar in any year touched. The code and year are substituted for your request; HOLIDAYS can still list the available dates.
#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.