Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Dates are numbers. Excel stores a date as a serial number, the count of days since 1900, and the date format only changes how it looks. YEAR, MONTH and DAY read the parts back out as plain numbers: MONTH of 15 Mar 2025 is 3.
=YEAR(C2) gives 2024 for a signup on 12 Mar 2024
You are tagging a sample of 2025 Brightline orders by month for the seasonality slide.
In C2:C9, return the month number (1 to 12) of each order date in column B.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Month | |||||
| 2 | 50001 | 2025-01-01 | ||||||
| 3 | 50094 | 2025-02-01 | ||||||
| 4 | 50186 | 2025-03-04 | ||||||
| 5 | 50279 | 2025-04-03 | ||||||
| 6 | 50372 | 2025-05-02 | ||||||
| 7 | 50557 | 2025-07-04 | ||||||
| 8 | 50654 | 2025-08-06 | ||||||
| 9 | 50848 | 2025-10-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