Confident Cells

Working days between two dates: NETWORKDAYS

20 November 2026 · 2 min read

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

  1. From 1 to 24 December is 24 days, counting both.
  2. That includes 3 weekends: 6 Saturdays and Sundays.
  3. 24 − 6 = 18 working days.
=NETWORKDAYS(B2,C2)
ABCD
1JobStartDueWorking days
2Report01/12/202624/12/202618
3Audit07/12/202611/12/20265
4Survey04/12/202607/12/20262
Monday to Friday is 5 working days, and Friday to Monday is 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)
ABCDEF
1LeaveFromToDaysBank holidays
2Sam21/12/202601/01/2027725/12/2026
3Ola28/12/202631/12/2026328/12/2026
401/01/2027
Sam's 10 weekdays include 3 bank holidays, so it is 7 days of leave. 28 December 2026 is the substitute day for Boxing Day, which falls on a Saturday.

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

Your turn

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.

ABCDEF
1LeaveFromToDaysBank holidays
2Sam21/12/202601/01/202725/12/2026
3Ola28/12/202631/12/202628/12/2026
4Raj14/12/202618/12/202601/01/2027
5Kim23/12/202604/01/2027
6Lee02/12/202609/12/2026