Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
DATE. DATE(year, month, day) builds a real date from three numbers. The result is a serial number, so it sorts, subtracts and works with every date function. It also rolls over: month 13 becomes January of the next year.
=DATE(2024,3,12) gives 12 Mar 2024
The carrier’s delivery file for June splits each delivery date into separate Year, Month and Day columns, which can’t be compared with Brightline’s order dates.
In E2:E8, build a real date from the year, month and day in columns B, C and D of each row.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Year | Month | Day | Delivered | |||
| 2 | 50500 | 2025 | 6 | 17 | ||||
| 3 | 50501 | 2025 | 6 | 18 | ||||
| 4 | 50502 | 2025 | 6 | 20 | ||||
| 5 | 50503 | 2025 | 6 | 17 | ||||
| 6 | 50504 | 2025 | 6 | 24 | ||||
| 7 | 50505 | 2025 | 6 | 18 | ||||
| 8 | 50506 | 2025 | 6 | 18 | ||||
| 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