Formuladrill

Level 4: Text and dates Exercise 73 of 118

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.

Functions used: NETWORKDAYS

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 exercise

More exercises in Text and dates