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

Stan, here is one way,

=SUMPRODUCT((YEAR(A1:A100)=2003)+0)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Stan Altshuller" <ctaca@hotmail.com> wrote in message
news:evyQ%23rAUFHA.2556@TK2MSFTNGP12.phx.gbl...
> 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
>
>

Stan,

The following will work, just not on a whole column

=SUMPRODUCT((YEAR(A1:A1000)=2003)*1)

HTH,
Bernie
MS Excel MVP


"Stan Altshuller" <ctaca@hotmail.com> wrote in message
news:evyQ%23rAUFHA.2556@TK2MSFTNGP12.phx.gbl...
> 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
>
>