Excel Formula – Calculate Current Quarter of the Year

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``` 