Level 2DatesPractice, 3 min
NETWORKDAYS: working days left
The task
A campaign build runs from B2 to C2. How many working days is that? In D2, use
NETWORKDAYS, and skip the company holidays listed in F2:F3.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Project | Start | End | Work days | Holidays | |
| 2 | Summer launch | Jun 1, 2026 | Jun 19, 2026 | Jun 19, 2026 | ||
| 3 | Jul 3, 2026 |