Stan,
The following will work, just not on a whole column
=SUMPRODUCT((YEAR(A1:A1000)=2003)*1)
HTH,
Bernie
MS Excel MVP
"Stan Altshuller" wrote in message
...
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
|