Counting items within a date range

Options

Hi, 

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. 

Manuel

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!