Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Quarter from a date. A quarter is three months, so the month number divided by 3 and rounded up gives the quarter: months 1–3 give 1, 4–6 give 2 and so on. Join it with the year using & to make a label that sorts and counts cleanly.
="FY"&YEAR(D2)&"-M"&MONTH(D2) gives FY2025-M3 for a refund on 19 Mar 2025
The board pack groups orders by quarter, written like 2025-Q3. You have a sample of 2025 orders and need the quarter of each one, then a count per quarter.
In C2:C11, build a quarter label like 2025-Q1 from each order date in column B (year, a dash, Q and the quarter number). In F2:F5, count the orders in each quarter listed in E2:E5.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Quarter | Quarter | Orders | |||
| 2 | 50001 | 2025-01-01 | 2025-Q1 | |||||
| 3 | 50094 | 2025-02-01 | 2025-Q2 | |||||
| 4 | 50186 | 2025-03-04 | 2025-Q3 | |||||
| 5 | 50279 | 2025-04-03 | 2025-Q4 | |||||
| 6 | 50557 | 2025-07-04 | ||||||
| 7 | 50654 | 2025-08-06 | ||||||
| 8 | 50751 | 2025-09-05 | ||||||
| 9 | 50848 | 2025-10-08 | ||||||
| 10 | 50945 | 2025-11-11 | ||||||
| 11 | 51042 | 2025-12-12 | ||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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