Counting items within a date range



I am trying to count the number of requests whose status is closed, and that were initially opened (Request Date) in the month of September 2019 (see extract of the table)

Hereunder is my table: 

Here is the formula that I entered, and generates a "#UNPARSEABLE" message: 

=COUNTIFS({Report Status}, "Closed", AND(@{Request Date} >= DATE(2019, 9, 1), @{Request Date} <= DATE(2019, 9, 30))) 

Thanks for your help. 


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!