Counting items within a date range

Manuel Chowrimootoo

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

Paul Newcome

Try this:

=COUNTIFS({Report Status}, "Closed", {Request Date}, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))

Paul Newcome

Try this:

=COUNTIFS({Report Status}, "Closed", {Request Date}, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))

Manuel Chowrimootoo

Hi Paul,

Thank you so much.

I overlooked at the 'IFERROR' and to call in the month and then the year.

Thanks again.

Paul Newcome

Happy to help! 👍️