Google Sheets

WORKDAY.INTL function in Google Sheets

Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

=WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

WORKDAY.INTL syntax and parameters

Four arguments, two required.

start_dateanyRequired
The date from which to begin counting.
num_daysnumberRequired
The number of working days to advance from start_date. If negative, counts backwards.
weekendanyOptional
[ OPTIONAL - 1 by default ] - A number or string representing which days of the week are considered weekends. String method: weekends can be specified using seven 0’s and 1’s, where the first number in the set represents Monday and the last number is for Sunday. A zero means that the day is a work day, a 1 means that the day is a weekend. For example, “0000011” would mean Saturday and Sunday are weekends. Number method: instead of using the string method above, a single number can be used. 1 = Saturday/Sunday are weekends, 2 = Sunday/Monday, and this pattern repeats until 7 = Friday/Saturday. 11 = Sunday is the only weekend, 12 = Monday is the only weekend, and this pattern repeats until 17 = Saturday is the only weekend.
holidaysanyOptional
[ OPTIONAL ] - A range or array constant containing the dates to consider holidays.

Formulas you'll actually reuse.

Ten working days on when only Sunday is off (weekend code 11):
```
=WORKDAY.INTL(DATE(2026, 9, 1), 10, 11)
```
Result2026-09-12
A delivery date from a start date, a lead time in days, a weekend mask and holidays:
```
=WORKDAY.INTL(B2, C2, "0000011", H2:H10)
```

Same name — your formula ports as-is.

Edit the example — nothing to install.

Preloaded with the WORKDAY.INTL formula from Example 1 — change anything and watch it respond.

Loading the editor…

What they mean — and the fixes.

#VALUE!
The weekend string isn't exactly seven 0/1 characters, or the weekend number isn't 1–7 or 11–17.

More ways Google Sheets gets this done.