NETWORKDAYS: working days between two dates
The reverse question: not when it ends, but how many working days it took.
Task:
For each project in the log, count the working days from start to finish, both included. Put the counts in D2:D5.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of WORKDAY
0/3The same formula in the other shapes it takes at work.
- WORKDAY Function
Calculate working days using WORKDAY.
CoreIntermediate - WORKDAY that skips bank holidays
The third argument is a list of dates that are not working days.
Intermediate - NETWORKDAYS: working days between two dates
The reverse question: not when it ends, but how many working days it took.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Start | Finish | Working days |
| 2 | Website | 3/4/2024 | 3/15/2024 | |
| 3 | Audit | 3/11/2024 | 3/11/2024 | |
| 4 | Move | 3/8/2024 | 3/12/2024 | |
| 5 | Launch | 4/1/2024 | 4/30/2024 |
What this exercise teachesMay contain the answer
Subtracting the dates counts calendar days and excludes one end, so a two-week project reads as 11. NETWORKDAYS counts the days people actually worked, which is the figure resourcing and billing need.