Count dates

[HeRoseInThree]

I am looking to count the number of times the event took place in January (1) or December (12).

I custom displayed the month to just 'mm' and used the formula =countif('Driver Data'!AO:AO,"01") for January or
=countif('Driver Data'!AO:AO,"12") for December

Any ideas?

 

[Joe4]

A custom format does not change the value actually in the cell, just how it is displayed.
Formulas run against the underlying values, not the formatted values.

So are the values in AO actually full dates, and not text?
If so, are they always the current year (all valid dates have a year component)?

 

[HeRoseInThree]

I wondered... I haven't thought that far ahead. Yeah, it could be all the same year.

 

[Joe4]

You could use COUNTIFS, with a date range (for the beginning/ending of the month).
Something like this: https://exceljet.net/formula/count-cells-between-dates

Let me know if you have issues getting that to work.

 

[HeRoseInThree]

Got it!
It took a while, but I got it. Of course, by I - I mean we!

Thanks!!!!

 

[Joe4]

You are welcome.