COUNTIF to determine the number of tickets created in a given month.


I am trying to figure how many tickets have been created by month using the formula below, but getting unparseable result.

Any help is much appreciated.

=COUNTIFS([Created Date]1:[Created Date]300, AND(@cell >= DATE(2020, 5, 1), @cell <= DATE(2020, 5, 31)))

Thank you,

Best Answers