Calculate Quarter from a Date – Excel & Google Sheets

This tutorial will demonstrate how to calculate the quarter from a date.

Quarter Main Function

Quarter of a Date

To calculate the quarter from a date, first we want to get the month number:

Get Month

Next we want to divide the month number by 3 (each quarter has 3 months) and use the ROUNDUP Function to round the result up to the nearest whole integer:

RoundUp

Next, we can concatenate text to the front of the result to say “Q1”, “Q2”, etc.:

Q Final

or “Quarter 1”, “Quarter 2”, etc.

Quarter Final

Calculate Quarter from a Date in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Quarter Google Sheet