Task 1 of 2
In D2:D4, calculate the finish date of each stage, skipping weekends and the holidays in G2:G5.
Lesson theory
WORKDAY(start, days, [holidays])is the date when a job lasting N workdays will be finished;NETWORKDAYS(start, end, [holidays])is how many workdays there are in a period.
Saturdays and Sundays are skipped automatically. Holidays are passed as a range of dates. Here that is column G.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.