This Excel Tutorial covers how to calculate the current quarter (Q1, Q2, Q3, Q4) from a date.

To calculate the current quarter from a date, use the following formula:

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

## The MONTH Function

The MONTH Function returns the current month for a given date. You can enter the date directly into the MONTH Function by using quotations (ex. “2/1/2015”) or reference a cell that contains a date.

`=MONTH("2/1/2015")`

Returns: 2

Next you want to divide the month number by 3. Why 3? There are 3 months in a quarter.

`=MONTH("2/1/2015")/3`

Returns: .667

## The ROUNDUP Function

The ROUNDUP Function rounds a number up to the nearest specified level of significance. So, if the current month is February. The Month will return 2. Divide 2 by 3 and get .667. Round .667 up and get 1, for Q1.

`=ROUNDUP(MONTH("2/1/2015")/3,0)`

Result: 1

If you’d like you can add a “Q” to the quarter so it reads “Q1” instead of “1”.

`="Q" & ROUNDUP(MONTH(date)/3,0)`

Result: Q1

Return to Formula Examples

## Leave A Comment