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.

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:
Solution examples
how do I derive the monthly sales from a date and revenue column
Solved by A. U. in 23 mins
I can't get this formula correct, can someone assist? I am trying to create a date for our posting process based on the payment terms. If a customer is paying biweekly, with a start date of 3/1/2018, etc. I want to be able to run daily what customers will need to be charged. =IF(OR(D2="MONTHLY",$C$6+30,")*IF(D2="WEEKLY",$C$6+7,"")*IF(D2="BIWEEKLY",$C$6+14,""""))
Solved by S. H. in 9 mins
HOW CAN I COUNT NUMBERS PER DAY FOR A MONTH AS TOTAL?
Solved by F. F. in 16 mins
a date formula that results in showing the date as 29/12/00 (date format as dd/mm/yy) - use column BA to calculate 364 days (same date format) in column BS, if BA blank, then calculate 364 days using column AX. Results for column BA are correct. However, if column BA is empty, then it should calculate using column AX, which has data, but the result is always 29/12/00, regardless of the date in column AX. I have used this formula with success in another workbook, but this file wont work! Formula: =IF(AND(LEN($BA74)=0,LEN($AX74)=0),"",IF(LEN($BA74)=0,DATE(YEAR($AX74),MONTH($AX74),DAY($AX74)+364),DATE(YEAR($BA74),MONTH($BA74),DAY($BA74)+364)))
Solved by A. L. in 60 mins
I need to sum the number of hours per month one of three halls are being rented
Solved by A. F. in 60 mins

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