In a formula-type column, the QUARTER() function displays the quarter number of a date-type column, and returns a number from 1 to 4. It is useful to structure quarterly reporting: aggregate revenue by quarter, track goals from Q1 to Q4.
Syntax
QUARTER(date_column)
Parameters
The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Examples
Extract the quarter from a date
QUARTER($Date)
For a date in April, the column returns 2 (2nd quarter).
Combine QUARTER() with YEAR() (or use YEAR_QUARTER()) to distinguish the same quarter across different years.
Go further
YEAR_QUARTER
Combine the year with the quarter for reliable reporting across multiple fiscal years.
Or continue with
Formula glossary
All available operators and functions, sorted by category.