Exercises / Dates and deadlines · 7 of 10
Delivery date in working days
WORKDAY(start, days, [holidays]) moves a date forward by a number of working days, skipping weekends and holidays.
Your taskEach order ships after a number of working days. In D2, use WORKDAY to return the ship date: the order date in B2 plus the working days in C2. It will be copied down to D7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Ordered | Days | Ships |
| 2 | #7001 | 5 Mar 2026 | 3 | |
| 3 | #7002 | 6 Mar 2026 | 2 | |
| 4 | #7003 | 9 Mar 2026 | 5 | |
| 5 | #7004 | 12 Mar 2026 | 7 | |
| 6 | #7005 | 13 Mar 2026 | 1 | |
| 7 | #7006 | 14 Mar 2026 | 4 |