Go Back

Get quarter from date

Read time: 20 minutes

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




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:



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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Formula to inert Quarter based on Date Value
Solved by Z. J. in 17 mins
Hi, I've uploaded a file. I want to walk backwards from the Go-live date and populate the required hours per quarter
Solved by C. C. in 28 mins
I'm trying to write an If statement that does the following: if the date in Column A falls in last month of a quarter, then take that date and add 30 days in Column B; if the date in Column A falls in the first or second month of the quarter, leave the original date in Column B.
Solved by I. J. in 12 mins

Leave a Comment