Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to get the quarter from a date in Excel and Google Sheets
Excel & Google Sheets
=ROUNDUP(MONTH(A2)/3,0)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your date in A2.
- 2In a result cell, enter =ROUNDUP(MONTH(A2)/3,0).
- 3MONTH(A2) extracts the month number (1-12); dividing by 3 maps to quarters (0.33-4); ROUNDUP rounds up to 1-4.
- 4To display as 'Q1', 'Q2', etc., prefix with text: ="Q"&ROUNDUP(MONTH(A2)/3,0).
- 5For a fiscal year starting in April, adjust: =ROUNDUP(MOD(MONTH(A2)-4+12,12)/3+1,0) to start Q1 in April.
Tips
- Store the quarter as a number (1-4) in a helper column for easy filtering and pivot table grouping, then format for display separately.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Does Excel have a built-in QUARTER function?
No. Excel does not have a native QUARTER function. The ROUNDUP(MONTH/3,0) formula is the standard workaround used by most Excel users.
How do I get the quarter for a non-calendar fiscal year?
Offset the month by your fiscal year start. For a July fiscal year start: =ROUNDUP(MOD(MONTH(A2)-7+12,12)/3+1,0) makes Q1 = July-September.