Working days between two dates: NETWORKDAYS
=NETWORKDAYS(start, end) counts the weekdays from one date to another, including both ends. Add a list of bank holidays as a third part and it leaves those out too.
A worked example
A job starts on Tuesday 1 December 2026 and must be done by Thursday 24 December. How many working days is that?
- From 1 to 24 December is 24 days, counting both.
- That includes 3 weekends: 6 Saturdays and Sundays.
- 24 − 6 = 18 working days.
=NETWORKDAYS(B2,C2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Job | Start | Due | Working days |
| 2 | Report | 01/12/2026 | 24/12/2026 | 18 |
| 3 | Audit | 07/12/2026 | 11/12/2026 | 5 |
| 4 | Survey | 04/12/2026 | 07/12/2026 | 2 |
Leaving out bank holidays
List the bank holidays in a few cells, then give that range as the third part. Lock it with $ so it stays put when you copy the formula down (see $ and F4):
=NETWORKDAYS(B2,C2,$F$2:$F$4)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Leave | From | To | Days | Bank holidays | |
| 2 | Sam | 21/12/2026 | 01/01/2027 | 7 | 25/12/2026 | |
| 3 | Ola | 28/12/2026 | 31/12/2026 | 3 | 28/12/2026 | |
| 4 | 01/01/2027 |
Adding working days: WORKDAY
To find the date 10 working days after an order, use =WORKDAY(B2,10), or =WORKDAY(B2,10,$F$2:$F$4) to skip bank holidays. Format the cell as a date.
Common mistakes
Subtracting the dates
=C2-B2 counts every day, weekends included, and leaves out the first day.
One day too many (or too few)
NETWORKDAYS counts both the start and the end date. For "working days from now until", that is usually what you want. If not, take 1 away.
The holiday list moves when copied
Without the $ signs, row 3 looks at F3:F5 and misses a holiday. Lock the range.
A different working week
For a working week other than Monday to Friday, Excel has NETWORKDAYS.INTL, which lets you choose which days are the weekend.
Try it now
In D2, work out how many days of leave each person is taking: the working days from the date in B to the date in C, leaving out the bank holidays in F2:F4. Your formula will be copied down to D6.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Leave | From | To | Days | Bank holidays | |
| 2 | Sam | 21/12/2026 | 01/01/2027 | 25/12/2026 | ||
| 3 | Ola | 28/12/2026 | 31/12/2026 | 28/12/2026 | ||
| 4 | Raj | 14/12/2026 | 18/12/2026 | 01/01/2027 | ||
| 5 | Kim | 23/12/2026 | 04/01/2027 | |||
| 6 | Lee | 02/12/2026 | 09/12/2026 |