WORKDAY
Finds the date that comes after a given number of working days, skipping weekends and holidays: a delivery date, a contract deadline.
WORKDAY(start_date, days, [holidays])- [ ]optional part
- start_date
- The date to count from, for example the order date.
- days
- How many working days to add. A negative number counts back.
- holidays
- Optional. A range with the dates of days off, for example $F$2:$F$3.Optional
Return value
The date that comes after the given number of working days, skipping Saturdays, Sundays and holidays. Without a date format, it shows as a number.
Examples
Delivery date
fx
A
B
C
D
E
F
G
1
2
3
4
5
6
Order
Order date
Lead time, days
Delivery
Holidays
#5401
02.10.2026
3
03.11.2026
#5402
07.10.2026
2
25.12.2026
#5403
30.10.2026
5
Sheet1
Details
WORKDAY counts working days from the start date. The start date itself doesn't count: Friday plus 1 working day is Monday.
The function skips Saturdays and Sundays by itself; holidays are passed as the third argument, a range of dates.
The result comes as a number, so give the cell a date format.
Common mistakes
- The cell shows a number instead of a date. Give it a date format.
- Expecting the start date to count too. WORKDAY starts counting from the next day.
- Without $ signs the holiday range shifts when you fill down.