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

System
Employee Admin
This discussion was created from comments split from: countif with dates.
Answers
-
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
-
@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))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!