How to Calculate Quarter in Excel Based on a Date

In this tutorial, we will guide you step-by-step through the process of creating a formula to calculate the quarter for a date in excel.

We want to get the calculate of the quarter from a date. To do this we will divide the month of a date by a quarter (3) and use the ROUNDUP function to get a whole digit. Simply type in the formula: =ROUNDUP(MONTH(A2)/3,0), where A2 is the cell that you have the date value stored. This formula will take the month of the date in cell A2 and divide it by 3. The result will then be rounded up to the nearest whole number.