How to Get Quarter and Year from a Date Property in Notion

When working with reports, timelines, or analytics in Notion, grouping data by quarter and year is a common requirement. Whether you're tracking projects, financial records, or content schedules, a Notion quarter formula lets you extract structured time periods from a date property automatically.

In this guide, you’ll learn how to calculate the quarter and year from any date in Notion using formulas that update dynamically.

Why Use a Notion Quarter Formula?

Notion doesn’t provide a built-in quarter property, but formulas fill that gap.

• Group records by quarter (Q1–Q4)
• Build quarterly reports and dashboards
• Improve filtering and sorting
• Support business and planning workflows
• Eliminate manual date categorization

A Notion quarter formula keeps your time-based data clean and consistent.

Understanding How Quarters Work

Quarters divide the year into four equal parts:

• Q1: January – March
• Q2: April – June
• Q3: July – September
• Q4: October – December

Notion formulas calculate quarters by extracting the month and mapping it to a quarter number.

Get the Year from a Date Property

To extract the year from a date property called Date, use:

formatDate(prop("Date"), "YYYY")

This returns the four-digit year as text.

Get the Quarter from a Date Property

The most reliable way to calculate the quarter is by converting the month into a quarter number.

"Q" + format(ceil(month(prop("Date")) / 3))

This formula:

• Extracts the month number (1–12)
• Divides it by 3
• Rounds up to determine the quarter
• Formats the result as Q1–Q4

Combine Quarter and Year in One Formula

To display a combined quarter and year (e.g. Q2 2025):

"Q" + format(ceil(month(prop("Date")) / 3)) +
" " +
formatDate(prop("Date"), "YYYY")

This is ideal for reporting, grouping, and timeline views.

Alternative: Fiscal Year Quarters

If your fiscal year doesn’t start in January, you can adjust the formula by shifting the month.

"Q" + format(
  ceil(
    mod(month(prop("Date")) + 2, 12) / 3
  )
)

This example assumes a fiscal year starting in April.

Common Use Cases

• Quarterly planning and OKRs
• Financial and budget reporting
• Content publishing schedules
• Sales and performance tracking
• Project timeline grouping

Final Thoughts

A Notion quarter formula is a simple yet powerful tool for organizing time-based data. By extracting the quarter and year from a date property, you can unlock cleaner reports, smarter filters, and more flexible dashboards.

If you work with dates in Notion, quarter-based formulas are a must-have.

Frequently Asked Questions