Date
NETWORKDAYS
Definition
NETWORKDAYS returns the number of workdays between two dates, counting both ends and skipping weekends.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
Arguments
| Argument | Meaning |
|---|---|
start_date |
The first date to count, or the cell holding it. |
end_date |
The last date to count, or the cell holding it. |
holidays |
Optional. Extra dates to skip, such as a list of public holidays. |
Worked example
A print shop counts workdays for each job. Starts are in A2:A4 and ends are in B2:B4.
| A: Start | B: End |
|---|---|
| 4 Mar 2024 | 6 Mar 2024 |
| 11 Mar 2024 | 15 Mar 2024 |
| 18 Mar 2024 | 18 Mar 2024 |
Formula: =NETWORKDAYS(A2,B2)
Result: 3. Monday 4 March 2024 through Wednesday 6 March 2024 are three workdays. Filled down, the formula gives 3, 5, and 1.
Practice
Cell A2 holds 1 January 2024 and cell B2 holds 5 January 2024. In C2, write a formula that returns the number of workdays from A2 through B2.
- In C2, write a NETWORKDAYS formula that returns the workdays from A2 to B2.
- C2 should show the workdays from A2 to B2.
Related functions
TODAY can be the end date when you want workdays from a start date through today.
Common mistake
Subtracting the dates, as in B2-A2+1: that counts Saturday and Sunday as well, so a weekend inside the span inflates the total.