Hi

I have a list of dates (in 12/12/2004 format) in a column. I need to seach how many dates are in the list with a year of 2004, regardless of day or month. I was using the countif function (=countif(a2:z2,"=2004") but it does not recognize any cells since there are months and days attached in the list. I also cannot change the list to show just years either....

I hope that this makes sense, and thanks for any help