---
title: "Display Fiscal Year Quarters In Airtable | Airtable Support "
slug: "displaying-quarters-in-a-fiscal-year"
description: "This article covers how to display the quarter of a fiscal year based on the date in another field in Airtable. "
updated: 2025-05-05T22:26:09Z
published: 2025-05-05T22:26:09Z
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.airtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Displaying fiscal year quarters in Airtable

This article covers how to display the quarter of a fiscal year based on the date in another field.

| [**Plan availability**](https://airtable.com/pricing) | All plan types |
| --- | --- |
| **Platform(s)** | Web/Browser, Mac app, and Windows app |
| **Related reading** | - [Getting started with formulas](/docs/getting-started-with-formulas) |

## Displaying fiscal year quarters

> NOTE
> 
> As an example, let's say your fiscal year runs from June through May; that means your first quarter (Q1) of the year would start on June 1. You can build a formula to output the correct quarter and fiscal year based on an existing date field.

To display fiscal year quarters, you’ll need to run a few formulas:

1. The first formula field will be used to output the quarter (based on the Date field):
  1. ```plaintext
IF(
  {DATE},
"Q"&ROUNDUP(VALUE(DATETIME_FORMAT(DATEADD({DATE}, 7, 'months'), 'M'))/3,
   0)
  )
```
2. Once that formula field is created, a second formula field is needed to reference the date and quarter fields, and generate the appropriate fiscal year:
  1. ```plaintext
IF({Date},
{Quarter} & " - FY'" &
 IF(MONTH({Date})>=6, DATETIME_FORMAT(DATEADD(Date, 1, 
'year'), 'YY'),DATETIME_FORMAT(Date, 'YY')))
```
  2. This will output and format the quarter and fiscal year of the record depending upon the information in the Date and Quarter fields:![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/formulas_fiscal_year_quarter_display_06062023.png)

If you’d prefer to run one formula for a combined field, you can:

- ```plaintext
IF({Date}, 
"Q"&ROUNDUP(VALUE(DATETIME_FORMAT(DATEADD({Date}, 7, 'months'), 'M'))/3,
   0)
   & " - FY'" & IF(MONTH({Date})>=6, 
DATETIME_FORMAT(DATEADD({Date}, 1, 'year'), 
'YY'),DATETIME_FORMAT({Date}, 'YY')))
```