Get First Day of Quarter in Excel (With Example)

---

You can use the following formula to get the first day of the quarter for a specific date in Excel:

=DATE(YEAR(A2),FLOOR.MATH(MONTH(A2)-1,3)+1,1)

This particular formula will return the first day of the quarter for the date in cell A2.

For example, if cell A2 contained the date 1/14/2023 then this formula would return 1/1/2023 since this represents the first day of the quarter that 1/14/2023 belongs in.

The following example shows how to use this formula in practice.

Example: How to Get First Day of Quarter in Excel

Suppose we have the following column of dates in Excel:

We can type the following formula into cell B2 to get the first day of the quarter for the date in cell A2:

=DATE(YEAR(A2),FLOOR.MATH(MONTH(A2)-1,3)+1,1)

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays the first day of the quarter for each corresponding date in column A.

Recall that there are four quarters in a year:

• Q1: January – March
• Q2: April – June
• Q3: July – September
• Q4: October – December

Thus, the first day of the quarter for each date will fall on one of the following dates:

• January 1st
• April 1st
• July 1st
• October 1st