Formuladrill

Level 4: Text and dates Exercise 74 of 118

Ship-by dates

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

Each order must ship a number of working days after the order date. Weekends do not count. Put the ship-by date in D2 and D3 with WORKDAY.

What this exercise teaches

Adding 3 to a Thursday lands on a Sunday. WORKDAY counts only Monday to Friday, so three working days after Thursday is the next Tuesday. A third argument takes a list of holidays.

A hint if you get stuck

WORKDAY(start date, days) moves forward by working days and skips Saturdays and Sundays.

Functions used: WORKDAY

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