Exercises / Dates and deadlines · 6 of 10

Working days in each project

NETWORKDAYS(start, end, [holidays]) counts the weekdays between two dates, both ends included, and skips any dates listed as holidays.

Your taskIn D2, use NETWORKDAYS to count the working days from the start date in B2 to the end date in C2, skipping the holidays in F2:F4. It will be copied down to D6.
Pro

Unlock this exercise and every module after the basics.

Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.

See plansI already have Pro
RowABCDEF
1ProjectStartEndWorking daysHolidays
2Website2 Mar 202610 Apr 20263 Apr 2026
3Audit16 Mar 202627 Mar 202625 May 2026
4Launch1 Apr 202630 Jun 20263 Jul 2026
5Hiring4 May 202631 Jul 2026
6Training1 Jun 202612 Jun 2026