NETWORKDAYS
Counts working days between two dates.
How it’s written
NETWORKDAYS(start, end)Example
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 46,097 | 46,101 |
=NETWORKDAYS(A2,B2)Result: 5
Monday to Friday is 5 working days, counting both ends.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
A third part can list holidays to skip.
Practice it properly
Tenure and working days gives you real tasks, with your formulas tested on data you haven’t seen.