SheetsdrillWorking days with holidays
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Count the working days (Monday to Friday) from start to due date, both included, leaving out the holidays in F2:F4. Fill D2 and D3 using NETWORKDAYS.
What this exercise teaches
NETWORKDAYS counts both the start and the end date, and only skips holidays that fall on weekdays.
A hint if you get stuck
NETWORKDAYS(start, end, holidays). Lock the holiday range so the formula can be filled down.
This exercise is part of Pro
Pro unlocks all 50 exercises, with worked solutions and progress saved to your account. The free exercises work without an account.
You create a free account first, so Pro is attached to it.
Monthly is charged today and then every month until you cancel, in one click from your account page. Lifetime is one payment with no renewals. Full refund within 14 days of paying.