COUNTIF Between Date Range


I am trying to see how many projects were completed in in 2021. I have several different dates and years within the column, but I'm looking for a count of all projects with a 2021 date. The below formula is what I'm using but I am getting #UNPARSEABLE.

=COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], >=DATE(2021, 1, 1) [NOC Recorded Date]:[NOC Recorded Date], <=DATE(2021, 12, 31))

I'd love help fixing if anyone can offer tips.


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 02/17/22 Answer ✓

    Use the AND function to give it two criteria to analyze from one single range. The @cell reference evaluates every cell at once. You were also missing a comma between your range/criteria sets.

    =COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], AND(@cell >=DATE(2021, 01, 01), @cell <= DATE(2021, 12, 31)))


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!