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

Options
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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!