View Single Post
  #1   Report Post  
Stan Altshuller
 
Posts: n/a
Default count number of years 2003 in a range of dates

Hi All!

I have a column of dates in column A:A and want to count the number of dates
that have the year 2003 in them.
I am trying to use =countif(year(A:A),2003) but it does not want to take
that formula, it says there is a mistake in it.

Can anyone help?

Thanks so much!!

Stan