Sheetsdrill

Level 5: Text and dates Exercise 89 of 92

Ship-by date in working days

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

Each order must ship a number of working days after the order date. Saturdays and Sundays do not count. Fill D2 and D3 using 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 range 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 Sheetsdrill 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