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.

=ROUNDUP(MONTH(DATE(2026,11,15))/3, 0)→4

November is in the fourth quarter.

=INT((MONTH(A2)+2)/3)→3

An equivalent formula; a date in August returns 3.

FAQ

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

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

How do I get the fiscal quarter when the year starts in April?

Shift the month first: =ROUNDUP(MONTH(EDATE(A2, -3))/3, 0). April to June then returns 1.

How do I get the first day of the quarter?

Use =DATE(YEAR(A2), 3*ROUNDUP(MONTH(A2)/3, 0)-2, 1).

Why does the formula return 1 for an empty cell?

An empty cell is treated as date 0, which Excel reads as January 1900. Guard it: =IF(A2="", "", 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