hi guys,

was wondering how to use countif function to count for overall months.

I have a column with numerous dates in dd/mm/yyyy format. I would like to count number of cells with a certain year, regardless of day and month. How do you do this?

At the moment, the countif function only works if I enter a specific date. E.g COUNTIF(A1:A3000, "1/31/1994"). I have tried substituting x, *, ~ for the month and day, but the count function still just returns 0.

Jodapo.