WORKDAY.INTL function
Quick answer
WORKDAY.INTL returns the date a number of working days before or after a start date, skipping the weekend days you choose and any holidays.
- Syntax
=WORKDAY.INTL(start_date, days, [weekend], [holidays])- Most common use
=WORKDAY.INTL(A2,B2)returns 3/10/2026 (Thursday plus 3 working days is Tuesday)
Use it for due dates and delivery estimates where the weekend isn't Saturday and Sunday, such as a Friday–Saturday week or a six-day week. The start date itself isn't counted.
- Available in
- Excel 2010 and later
- Category
- Date functions
- Returns
- A date serial number; format the cell as a date.
- Google Sheets
- Works the same in Google Sheets.
Syntax
=WORKDAY.INTL(start_date, days, [weekend], [holidays])
| Argument | Required? | What it is |
|---|---|---|
start_date | Required | The date to count from. It isn't counted as one of the days. |
days | Required | How many working days to move; negative counts backward. |
weekend | Optional | Optional: a code (1 Saturday–Sunday, 7 Friday–Saturday, 11 Sunday only…) or seven 0s and 1s from Monday to Sunday. |
holidays | Optional | Optional: a range of dates to skip. |
Examples
Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.
| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | =WORKDAY.INTL(A2,B2) | 3/10/2026 | Thursday plus 3 working days is Tuesday |
| D2 | =WORKDAY.INTL(A2,B2,11) | 3/9/2026 | With only Sunday off, Saturday counts: Monday |
| E2 | =WORKDAY.INTL(A2,B2,"0000111") | 3/11/2026 | With Friday to Sunday off: Wednesday |
Try it live
This is the sample sheet. Change any number or text, or edit a formula, and the results update.
Show the sample data as a table
| Start | Days | Sat–Sun off | Sun off | Fri–Sun off |
| 3/5/2026 | 3 | 3/10/2026 | 3/9/2026 | 3/11/2026 |
Practice WORKDAY.INTL
Graded instantly, then re-checked on changed data.
Due dates with Sunday off
C2, calculate each due date from the date in A2 and the days in B2, with Sunday off. Fill down to C6.Common mistakes
| What you see | Why, and how to fix it |
|---|---|
| A five-digit number | The result is a date serial number. Format the cell as a date. |
| #NUM! | The weekend code isn't valid, such as 0 or 8. |
| The deadline is a day early | The start date doesn't count: WORKDAY.INTL(A2,1,…) is the next working day after A2. |
Tips
- To keep a date that is already a working day, use =WORKDAY.INTL(A2-1,1,weekend).
Questions
How do I add working days with a custom weekend?
=WORKDAY.INTL(A2,10,7) adds 10 working days with Friday and Saturday off.
Can the weekend be a single day?
Yes: 11 is Sunday only and 17 Saturday only, or use a string like "0000001".
Updated Checked by running: every formula on this page was run by our formula engine on .