The Excel WORKDAY.INTL function is WORKDAY with a configurable weekend — perfect when your “weekend” isn’t Saturday–Sunday (Fri–Sat in much of the Middle East, Sunday-only, or any custom pattern).
Syntax
| Argument | Description | |
|---|---|---|
start_date | Required | The starting date (not counted). |
days | Required | Working days forward or back. |
weekend | Optional | Weekend code (1–17) or a 7-character mask like "0000011" (Mon–Sun, 1 = day off). |
holidays | Optional | Optional dates to skip. |
How to use it
The weekend can be a built-in code (1 = Sat–Sun, 7 = Fri–Sat, 11–17 = single-day weekends) or a 7-character mask string — the real power. "0000011" means Mon–Fri working, Sat–Sun off; "0001000" means only Thursday off:
Remember Excel’s date system: every date is a serial number (days since Jan 1, 1900 — so 1 = that day, 46000-ish = today) and every time is a fraction of a day (0.5 = noon). If a result shows a raw number, just apply a date or time cell format.
Try it: interactive demo
Adjust the input and watch the formula and result update.
Tips & gotchas
WORKDAY with a configurable weekend - custom or non-Sat/Sun work weeks. Format result cells as Date or Time so they don’t display raw serial numbers.
Practice workbook
Frequently asked questions
What’s the weekend mask format?
What are the numeric codes?
WORKDAY vs WORKDAY.INTL?
Which versions have it?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class