Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
| Parameter | Description |
|---|---|
| start_date | Parameter of the WORKDAY.INTL function. |
| days | Parameter of the WORKDAY.INTL function. |
| [weekend] | (Optional.) Parameter of the WORKDAY.INTL function. |
| [holidays] | (Optional.) Parameter of the WORKDAY.INTL function. |
Examples
10 business days from today (standard weekend)
Formula
=WORKDAY.INTL("2026-04-09", 10, 1)
2026-04-23. Counts 10 working days forward, skipping Saturdays and Sundays.
Deadline with Friday-Saturday weekend
Formula
=WORKDAY.INTL("2026-04-09", 10, 7)
2026-04-23. Weekend code 7 treats Friday and Saturday as non-working days, common in Middle Eastern schedules.
Delivery date excluding holidays
Formula
=WORKDAY.INTL("2026-12-20", 5, 1, {"2026-12-25","2026-12-26"})
2026-12-31. Skips Christmas Day and Boxing Day in addition to weekends.
Common Errors
#VALUE!
The start_date is not a valid date or the days argument is not numeric.
#NUM!
The weekend argument is invalid (e.g., a weekend string of all 1s, meaning every day is a weekend).
Tips
Custom weekend strings
Instead of a number code, pass a 7-character string of 0s and 1s (Monday-Sunday) where 1 means weekend. For example, "0000011" is a standard Sat-Sun weekend.
Counting backward
Use a negative number for the days argument to find a date in the past. For example, WORKDAY.INTL(TODAY(), -5, 1) gives the date 5 business days ago.
Holiday list from a range
Store your company holidays in a named range like Holidays and reference it as the fourth argument for easy maintenance across multiple formulas.
Try WORKDAY.INTL in Viztab
Import your data and use WORKDAY.INTL with 370+ other formulas. No signup required.
Open Viztab