ExcelHeroThe NETWORKDAYS function
Counts the working days (Mon–Fri) between two dates, both included.
In German Excel: NETTOARBEITSTAGE
How to write it
=NETWORKDAYS(start_date, end_date, [holidays])- start_date
- The first date.
- end_date
- The last date.
- holidays
- Optional. Days off that don’t count.
💡 If the end is before the start, the result is negative.
Try it
How many working days does the design phase take?
A
B
C
D
1
Task
Start
End
Workdays
2
Design
6/2/25
6/13/25
3
Build
6/16/25
7/11/25
4
Test
7/14/25
7/25/25
5
6
Holidays
6/9/25
6/19/25
=NETWORKDAYS(start, end).