I'm trying to get the number of support tickets for each month. In my first tab "Tickets" I have:
The date values have the following characteristics:
In my second tab I have:
I want to know how much tickets for each month. I've tried this:
= COUNTIFS(Tickets!B2:B196;">=1/06/17";Tickets!B2:B196;"<=31/06/17")
But that results in 0, which is not correct. Can you help me?