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 calendar quarter from a date in Excel and Google Sheets
Excel & Google Sheets
=QUARTER(A2)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 dates in column A starting from cell A2.
- 2In cell B2, enter the formula =QUARTER(A2) for Excel or =QUARTER(A2) for Google Sheets.
- 3Drag the fill handle down to apply the formula to other cells in column B.
Tips
- Ensure your date format is recognized by Excel or Google Sheets to avoid errors.
- The QUARTER function works consistently across different locales in both Excel and Google Sheets.
- If your dates are text, convert them to date format using DATEVALUE() before applying the QUARTER function.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my date is in a different format?
Convert your date to a standard date format using DATEVALUE() before using the QUARTER function.
Can I use this formula with a range of dates?
Yes, apply the formula to each cell individually or use an array formula if supported by your version.
Does this work with fiscal quarters instead of calendar quarters?
No, QUARTER() calculates calendar quarters. For fiscal quarters, you may need a custom formula.