Dates & Time

Excel formula for Get the quarter from a date

Convert a date into its calendar quarter (1–4).

Copy this formula

=ROUNDUP(MONTH(A2)/3, 0)

How the formula works

MONTH returns 1–12; dividing by 3 and rounding up groups months into quarters (Jan–Mar → 1, Apr–Jun → 2, and so on). Concatenate with "Q" for a label like Q2.

Examples

="Q"&ROUNDUP(MONTH(A2)/3, 0)→Q2

April falls in Q2.

FAQ

How do I include the year, like 2026-Q2?

=YEAR(A2)&"-Q"&ROUNDUP(MONTH(A2)/3,0).

Related formulas

Get the month name from a date Get the week number from a date

Functions used

ROUNDUP MONTH

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free