The simplest way would be to use this format of formula: =COUNTIFS(<Range>, ">=<StartDate>", <Range>, "<=<EndDate>") Your formulas would look like this: Q1 =COUNTIFS($A$1:$A$1000,">=1/1/2018",$A$1:$A$1000,"<=1/3/2018") Q2 =COUNTIFS($A$1:$A$1000,">=4/1/2018",$A$1:$A$1000,"<=6/30/2018") Q3 =COUNTIFS($A$1:$A$1000,">=7/1/2018",$A$1:$A$1000,"<=9/30/2018") Q4 =COUNTIFS($A$1:$A$1000,">=10/1/2018",$A$1:$A$1000,"<=12/31/2018")

This might be too complicated for what you want but a more general solution would be this style of formula: = SUMPRODUCT(1(MONTH(<Range>) <= 3<Quarter>), 1(YEAR($A$1:$A$1000)=<Year>)) - SUMPRODUCT(1(MONTH(<Range>) < 3(<Quarter> - 1) + 1), 1(YEAR($A$1:$A$1000)=<Year>))

The formula looks complicated but all you'd have to do is change <Range> to the range of your cells, <Year> to the year you want to count and <Quarter> for the quarter you want Your formula might look like this, with your quarter as a variable in the B1 cell: = SUMPRODUCT(1(MONTH($A$1:$A$1000) <= 3B1), 1(YEAR($A$1:$A$1000)=2018)) - SUMPRODUCT(1(MONTH($A$1:$A$1000) < 3(B1 - 1) + 1), 1(YEAR($A$1:$A$1000)=2018))

This counts all the dates in months 1-3 for Q1, 4-6 for Q2, etc in the specified year. This way you only have to type the formula once and have something like a data validation dropdown selection in B2 to change the quarter, or you could do something similar with the year.