Deadlines in working days with WORKDAY
When does each order arrive? Count the working days in C2:C7 from the order date, skipping weekends and bank holidays.
keyboard Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Working days | Delivery date | Bank holidays | ||
| 2 | #5100 | 8 Apr 2026 | 5 | 3 Apr 2026 | |||
| 3 | #5106 | 2 Apr 2026 | 15 | 6 Apr 2026 | |||
| 4 | #5110 | 29 Apr 2026 | 8 | 4 May 2026 | |||
| 5 | #5112 | 7 Apr 2026 | 12 | 25 May 2026 | |||
| 6 | #5128 | 26 Mar 2026 | 15 | ||||
| 7 | #5115 | 1 Apr 2026 | 6 | ||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 |
How WORKDAY works
What does
WORKDAYdo?It finds the date a number of working days after a start date, skipping Saturdays, Sundays and any holidays you list:
=WORKDAY(B2,C2, $F$2:$F$5) Why not just add the days?
=B2+C2counts every day, weekends included. Five working days from a Friday is the next Friday, but Friday plus 5 is Wednesday.Does the start date count?
No.
WORKDAYcounts from the day after the start, like a delivery promise: one working day after Friday is Monday.How do holidays work?
List the holiday dates in a range and give it as the third part. Lock it with $ so it stays put when you copy the formula down.
Can I count backwards?
Yes: a negative number of days goes back, e.g.
=WORKDAY(B2,-3)for a date three working days before a deadline.WORKDAY.INTLlets you choose different weekend days.
Know someone fighting with a spreadsheet? Send them this page.