countif with date range


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?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!