← Back to level 2
Level 2Next
NETWORKDAYS
A medium date formula for counting working days between two dates while skipping weekends.
Syntax
=NETWORKDAYS(...)Step-by-step explanation
- 1Use a date or time formula when the result should update automatically.
- 2Place the function in the cell where you need a live date or time value.
- 3Format the cell if needed so the output is easy to read.
Common mistakes
Forgetting holidays can be included separately
Using it for calendar days by mistake
Entering dates as text instead of date values
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=NETWORKDAYS(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =NETWORKDAYS(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use NETWORKDAYS when you need elapsed workdays for deadlines or scheduling.
Match against the syntax block above.