countif with date range

Tracy Ashton · 02/23/22

Hi all. I am trying to count the number of line items in March 2022. This is my equation.

=COUNTIF([Planned Pull Date]:[Planned Pull Date], >=DATE(2022, 3, 1), <=DATE(2022, 3, 31))

It comes up is incorrect argument set. What am I doing wrong?

Jeff Reisman · 02/23/22

You're close! You can use AND to consider two (or more) criteria for the same range.

=COUNTIF([Planned Pull Date]:[Planned Pull Date], AND(@cell >=DATE(2022, 3, 1), @cell <=DATE(2022, 3, 31)))

Alternatively, you can use YEAR and MONTH:

=COUNTIF([Planned Pull Date]:[Planned Pull Date], AND(YEAR(@cell) = 2022, MONTH(@cell) = 3))

Tracy Ashton · 02/23/22

You are a genius! Thank you so much @Jeff Reisman

Jeff Reisman · 02/23/22

You're close! You can use AND to consider two (or more) criteria for the same range.

=COUNTIF([Planned Pull Date]:[Planned Pull Date], AND(@cell >=DATE(2022, 3, 1), @cell <=DATE(2022, 3, 31)))

Alternatively, you can use YEAR and MONTH:

=COUNTIF([Planned Pull Date]:[Planned Pull Date], AND(YEAR(@cell) = 2022, MONTH(@cell) = 3))

Tracy Ashton · 02/23/22

You are a genius! Thank you so much @Jeff Reisman

Jeff Reisman · 02/23/22

If only my teenage kids recognized that, LOL.

Happy I could help!

Best Answers