COUNTIF Between Date Range

KristiTRUSD

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.

Jeff Reisman

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

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

KristiTRUSD

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