Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles DATE AND TIME Get quarter from date

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

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.

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

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

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

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc