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

Question

Hello,

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,

John Jonassen · Accepted Answer

Try this:

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

Tana Rucker · Accepted Answer

Another solve could include the pivot app.