FormuladrillCalendar quarter
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Label each order with its calendar quarter as text: Q1 for January to March, Q2 for April to June, Q3 for July to September, Q4 for October to December. Fill B2:B4.
What this exercise teaches
ROUNDUP(month/3,0) maps months 1 to 3 to 1, 4 to 6 to 2, 7 to 9 to 3 and 10 to 12 to 4. For a fiscal year that starts in another month, shift the month number before dividing.
A hint if you get stuck
MONTH gives 1 to 12. Divide by 3, ROUNDUP to a whole number, then join "Q" in front with &.
Try it now, free, no account needed
The first 15 tasks on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exercise