Working days on a task
An Excel formula exercise from Formuladrill. 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 each task takes, from the start date to the end date with both included. Weekends do not count, and neither does the public holiday in G1. Fill D2 and D3.
What this exercise teaches
Subtracting two dates counts every calendar day. NETWORKDAYS skips Saturdays and Sundays and any holiday you list, which is what delivery times and service levels are usually measured in.
A hint if you get stuck
NETWORKDAYS(start, end, holidays) counts Monday to Friday, both ends included, and leaves out the dates given as holidays.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- Build an email address
- Pull out the domain
- Payment due dates
- Clean up names
- Join the tags
- Digits only
- Days between dates
- Year and month
- Contract end date
- Pay by month end
- Split last name, first name
- Calendar quarter
- Month labels with TEXT
- IDs with leading zeros
- Mask an account number
- File extension
- Completed years of service
- Ship-by dates
- Weekend or weekday
- Days in the month