Get quarter from date

★ 20 minutes read

In this tutorial, you will learn how to get quarter from date in Excel. To be able to calculate a quarter, you will have to get familiar with MONTH and ROUNDUP functions. The MONTH function returns a month from a date, while ROUNDUP function rounds a ratio.

Get quarter from date

Formula

=ROUNDUP(MONTH(date)/3,0)

Explanation

Let’s first look at MONTH function definition. This function returns a month of a selected date. For January, it will return 1, for February 2, for March 3, etc. The only parameter of the function MONTH is a date for which we want to get a month.

ROUNDUP function rounds a number to a specific number of decimal digits. The first parameter of the function is Number which we want to round up – in our case that will be a month of a date divided by 3 (because a quarter has 3 months). The second parameter is Number of digits – on which we want to round a decimal number – in our case, it will be 0, so we can get a quarter.

Example 1

In our example, we have dates in column B (“Date”), while in column C we want to get a quarter from a date (“Quarter from date”). Let’s look at the formula:

=ROUNDUP(MONTH(B3)/3,0)

 

Figure 1. Get quarter from date

 

The MONTH(B3) will return 6, as the date in the cell B3 is in month June. The number 6 will be number parameter for ROUNDUP function, so we will round up 2 (6/3) on 0 decimals. This is 2 – the second quarter (cell C3).

If you look at the second row (Cell B4), you will see that function MONTH(B4) will return 2, as the date in the cell B4 is in month February. The ROUNDUP function will take 0.66667 as number parameter (2/3) and round it up on 0 decimals. As this function rounds a number to a greater value, we will get 1 in the cell C4 – the first quarter.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar