# COUNTIF Between Date Range

Options
✭✭✭

Hello,

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.

Tags:

• ✭✭✭✭✭✭
Options

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)))

Regards,

Jeff Reisman

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

• ✭✭✭✭✭✭
Options

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)))

Regards,

Jeff Reisman

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

• ✭✭✭
Options

@Jeff Reisman thank you for your help! That worked perfectly for me.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!