I am trying to count the number of occurrences with a date list by year. I have list of dates that are spread out over several years with some Text note in the adjacent column proclaiming something happen on that date.

The data entered into the cell is 12/31/2006 format.

I have tried the count function which returns a total count of entries regardless of the year. I then tried the countif function which return a value of zero.

I tried wild cards (* and ~) to no avail thought this is the first time using them. Is it the wild cards or the count function that I am messing up?

=COUNTIF(A5:A93,"*2006")