Course
Project: project schedule
Build the schedule of a real website project: count working days without weekends and holidays, plan the testing phase, date the invoices and report the working days left on a status date.
Exercise 1 of 6
Count the working days of each task
This is the schedule of a website redesign. In D2:D7, count the working days of each task, from its start date (column B) to its end date (column C), with NETWORKDAYS.
| Task | Start | End | Workdays | |
| Kick-off & brief | 02/03/2026 | 06/03/2026 | ||
| Design | 09/03/2026 | 27/03/2026 | ||
| Content writing | 16/03/2026 | 10/04/2026 | ||
| Development | 30/03/2026 | 08/05/2026 | ||
| Integration | 11/05/2026 | 26/05/2026 | ||
| Training | 27/05/2026 | 05/06/2026 |