WORKDAY.INTL function
WORKDAY.INTL returns the date a given number of working days away, like WORKDAY, but lets you choose the weekend pattern. It suits regions with Friday and Saturday weekends or rotating shifts.
Example
Read it as a sentence: find the workday 1 day after January 16, 2026, using weekend code 1 for Saturday and Sunday off and skipping the holidays in H1:H3, which gives 46042.
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Arguments in [square brackets] are optional.
-
start_date(required) - Starting date.
-
days(required) - Working days to move.
-
weekend(optional) - Number code or 7-character 0/1 string (starting Monday) defining weekend days.
-
holidays(optional) - Optional list of dates to skip.
Returns: The date a given number of working days away, with a custom weekend.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=WORKDAY.INTL(DATE(2026,1,8),1,7) | 46033 | Friday-Saturday weekend |
=WORKDAY.INTL(DATE(2026,1,8),1,"0000110") | 46033 | String weekend |
=WORKDAY.INTL(DATE(2026,1,9),-3,11) | 46028 | Sunday-only weekend backwards |
=WORKDAY.INTL(DATE(2026,1,16),1,1,Data!H1:H3) | 46042 | Holidays |
=WORKDAY.INTL(DATE(2026,1,8),1,"1111111") | #VALUE! | All weekend |
=WORKDAY.INTL(DATE(2026,1,8),1,99) | #NUM! | Bad code |
The Data sheet these formulas read
A cell that starts with = holds that formula.
Watch out for
- Code 11 is Sunday only; code 7 is Friday and Saturday.
- In the string, 1 means non-working and the first character is Monday.
Where it works
- Excel
- WORKDAY.INTL arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .