# WORKDAY.INTL function in Excel

> 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.

Source: https://spreadsheetpractice.com/functions/workday-intl · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on October 30, 2026

## Quick answer

- **What it does:** 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)
- **Available in:** Excel 2010 and later
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A date serial number; format the cell as a date.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

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. 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.

## 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 was calculated by running the formula on the sample sheet.

| 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 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Start | Days | Sat–Sun off | Sun off | Fri–Sun off |
| 2 | 3/5/2026 | 3 | 3/10/2026 | 3/9/2026 | 3/11/2026 |

## 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).

## Related functions

- [WORKDAY](https://spreadsheetpractice.com/functions/workday): WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.
- [NETWORKDAYS.INTL](https://spreadsheetpractice.com/functions/networkdays-intl): NETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you say which days are the weekend: Friday and Saturday, Sunday only, or any pattern written as a seven-character string such as "0000011".
- [EDATE](https://spreadsheetpractice.com/functions/edate): EDATE returns the date a given number of months before or after a start date, keeping the same day of the month.

## 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".

## Practice

A graded WORKDAY.INTL exercise ("Due dates with Sunday off") is on [the WORKDAY.INTL page](https://spreadsheetpractice.com/functions/workday-intl). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.