Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
WORKDAY. WORKDAY(start, days, holidays) returns the date that is days working days after start, jumping over weekends and any dates in the holidays range. It is the forward version of NETWORKDAYS: give it a date and a count, and it gives back a date.
=WORKDAY(D2,10,$K$2:$K$5) the date a refund is due, ten working days on
Ops is testing a new delivery promise: the promised days in column C count as working days, skipping weekends and the holidays in G2:G3. You asked the AI assistant for each order’s promise date.
AI assistant: “Done! D2:D8 uses WORKDAY with the holiday list, so weekends and holidays are skipped.”
Check the AI’s formulas in D2:D8. Fix them so each row returns the date that is the promised number of working days after the order date, skipping weekends and both holidays.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Promised days | Promise date | Holiday | Date | ||
| 2 | 50548 | 2025-07-02 | 4 | 2025-07-09AI | Memorial Day | 2025-05-26 | ||
| 3 | 50431 | 2025-05-22 | 4 | #N/AAI | Independence Day | 2025-07-04 | ||
| 4 | 50436 | 2025-05-23 | 5 | #N/AAI | ||||
| 5 | 50445 | 2025-05-27 | 3 | #N/AAI | ||||
| 6 | 50553 | 2025-07-03 | 2 | #N/AAI | ||||
| 7 | 50550 | 2025-07-02 | 3 | #N/AAI | ||||
| 8 | 50432 | 2025-05-22 | 3 | #N/AAI | ||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe