countif with date range

Tracy Ashton

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

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

AND Function | Smartsheet Learning Center

Tracy Ashton

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

Jeff Reisman

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

AND Function | Smartsheet Learning Center

Tracy Ashton

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

Jeff Reisman

https://community.smartsheet.com/discussion/comment/320585#Comment_320585

If only my teenage kids recognized that, LOL.

Happy I could help!