# Google Sheets: Convert Date to Quarter and Year

You can use one of the following formulas to convert a date to a quarter and year in Google Sheets:

Formula 1: Convert Date to Quarter Only (e.g. Q1)

```="Q" &INT((MONTH(A1)+2)/3)
```

Formula 2: Convert Date to Quarter and Year (e.g. Q1-2022)

```="Q" &INT((MONTH(A1)+2)/3) & "-" & YEAR(A1)
```

Formula 3: Convert Date to Full Quarter Name and Year (e.g. Quarter 1 2022)

```="Quarter " &INT((MONTH(A1)+2)/3) & " " & YEAR(A1)
```

Note that each formula assumes the date is in cell A1.

The following examples show how to use each formula in practice.

## Example 1: Convert Date to Quarter Only

We can use the following formula to convert a date to a quarter only:

`="Q" &INT((MONTH(A2)+2)/3)`

We can type this formula into cell B2 and drag the formula down to every remaining cell in column B:

The quarter for each date in column A is shown in column B.

## Example 2: Convert Date to Quarter and Year

We can use the following formula to convert a date to a quarter and year:

`="Q" &INT((MONTH(A2)+2)/3) & "-" & YEAR(A2)`

We can type this formula into cell B2 and drag the formula down to every remaining cell in column B:

The quarter and year for each date in column A is shown in column B.

## Example 3: Convert Date to Full Quarter Name and Year

We can use the following formula to convert a date to a full quarter name and year:

`="Quarter " &INT((MONTH(A2)+2)/3) & " " & YEAR(A2)`

We can type this formula into cell B2 and drag the formula down to every remaining cell in column B:

The quarter and year for each date in column A is shown in column B.

The following tutorials explain how to perform other common tasks in Google Sheets:

May 13, 2024
April 25, 2024
April 19, 2024

## 2 Replies to “Google Sheets: Convert Date to Quarter and Year”

1. Ailsa says:

How do I use this formula if my fiscal year start in October not January?

2. Bernard Horowitz says:

This is great but what if the field is blank? In the formula provide it assumes that there is a date but when there is not a date it throws in Q4 which.

Example: If you have a column A named Completed Date) but the work is not yet completed. That field is blank. How do I change the formula to respect the blank field and not put a quarter in?