Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
NETWORKDAYS. NETWORKDAYS(start, end, holidays) counts the weekdays from start to end, both included, and skips any dates in the holidays range. Keep the holiday list in cells and lock the range with $ so it stays put when you fill down.
=NETWORKDAYS(D2,E2,$K$2:$K$5) working days a refund took to process
Carriers are paid on working days, not calendar days. Weekends don’t count, and neither do the two public holidays listed in G2:G3 (Memorial Day and Independence Day).
In D2:D9, return the number of working days from the order date in column B to the delivered date in column C, counting both days and skipping weekends and the holidays in G2:G3.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Delivered | Working days | Holiday | Date | ||
| 2 | 50428 | 2025-05-21 | 2025-05-24 | Memorial Day | 2025-05-26 | |||
| 3 | 50430 | 2025-05-21 | 2025-05-27 | Independence Day | 2025-07-04 | |||
| 4 | 50433 | 2025-05-22 | 2025-05-29 | |||||
| 5 | 50436 | 2025-05-23 | 2025-05-27 | |||||
| 6 | 50440 | 2025-05-25 | 2025-05-29 | |||||
| 7 | 50446 | 2025-05-27 | 2025-06-01 | |||||
| 8 | 50548 | 2025-07-02 | 2025-07-10 | |||||
| 9 | 50550 | 2025-07-02 | 2025-07-08 | |||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=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