count the number of dates in a column within each three month period

System

This discussion was created from comments split from: countif with dates.

Bernard Schultz

Hi

I am trying to count the number of dates in a column within each three month period in a year, below is for the first three months of 2019, i am using the following formula trying to follow what you have advised above, but i am still getting an error: #unparseable. I am not sure if there should be another AND in the formula or where i am going wrong?

=COUNTIFS({Study Status Tracker Range 1},AND(IFERROR(MONTH(@cell), 0)<=3,IFERROR(MONTH(@cell), 0) >0)),IFERROR(YEAR(@cell), 0) = 2019)))

Thank you

Paul Newcome

@Bernard Schultz You have one too many closing parenthesis on the end.

=COUNTIFS({Study Status Tracker Range 1},AND(IFERROR(MONTH(@cell), 0)<=3,IFERROR(MONTH(@cell), 0) >0)),IFERROR(YEAR(@cell), 0) = 2019))