Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
DAYS. DAYS(end_date, start_date) returns the number of days between two dates. Note the order: the later date comes first. It gives the same answer as subtracting the dates, but reads clearly in a long formula.
=DAYS(E2,D2) days from an order date in D2 to a refund date in E2
The logistics review compares carriers on how long a parcel spends between leaving the warehouse and reaching the customer. These are mid-June shipments.
In D2:D9, use DAYS to return the number of days from the shipped date in column B to the delivered date in column C.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Shipped | Delivered | Days in transit | Carrier | |||
| 2 | 50500 | 2025-06-15 | 2025-06-17 | ParcelLine | ||||
| 3 | 50501 | 2025-06-14 | 2025-06-18 | Greenway Logistics | ||||
| 4 | 50502 | 2025-06-16 | 2025-06-20 | ParcelLine | ||||
| 5 | 50503 | 2025-06-16 | 2025-06-17 | Rapid Freight | ||||
| 6 | 50504 | 2025-06-18 | 2025-06-24 | ParcelLine | ||||
| 7 | 50505 | 2025-06-17 | 2025-06-18 | ParcelLine | ||||
| 8 | 50506 | 2025-06-16 | 2025-06-18 | Rapid Freight | ||||
| 9 | 50507 | 2025-06-19 | 2025-06-21 | ParcelLine | ||||
| 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