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.
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 exerciseMore exercises in Text and dates
- First name with SPLIT
- Join the confirmed names
- Address without gaps
- Valid order IDs
- Pull out the invoice number
- Digits only
- Month label with TEXT
- Full years of service
- Working days with holidays
- Due at the end of next month
- Tidy up pasted names
- Items in a comma list
- Domain of an email address
- Renewal date with EDATE
- Orders placed at the weekend
- Amount inside a sentence
- The part before the @
- Mask an account number
- Day of the week as a word
- Days until the deadline
- Flag addresses that are not emails