You're a finance analyst tagging 12 transaction dates with their fiscal quarter for the company's reporting cube. The fiscal year starts April 1, so:
| Calendar months | Fiscal Quarter |
|---|
| April – June | Q1 |
| July – September | Q2 |
| October – December | Q3 |
| January – March | Q4 |
(Yes, January–March falls into Q4 of the prior fiscal year — that's the consequence of an April-start calendar.)
Your task:
- In column C (Fiscal Quarter), write a formula that returns one of the literal strings
Q1, Q2, Q3, Q4 based on the date in column B.
- The formula must drag-fill from C2 → C13.
The recommended pattern is MONTH + IFS, ordered most-specific-first so that the high-month branches (Oct-Dec → Q3) match before the catch-all (Jan-Mar → Q4):
=IFS(MONTH(B2) >= 10, "Q3", MONTH(B2) >= 7, "Q2", MONTH(B2) >= 4, "Q1", TRUE, "Q4")
Graded cells: C2 (2026-01-15 → Q4), C5 (2026-04-10 → Q1), C11 (2026-10-05 → Q3).
Open this problem on a desktop to attempt it.