Counting number of occurrences

I have a column with several hundred entries in date format m/d/yyyy. Is
there a formula to count the number of occurrences for each unique value of
yyyy? In other words how many of the dates fall within 2003, 2004, 2005,
etc. Thanks.

Hi,

How about:

=SUMPRODUCT(--(YEAR(A1:A1000)=2004))

Regards,
KL


"LyleB_Austin" <LyleBAustin@discussions.microsoft.com> wrote in message
news:A16CD698-8A48-4D97-9542-DE4668743CAD@microsoft.com...
>I have a column with several hundred entries in date format m/d/yyyy. Is
> there a formula to count the number of occurrences for each unique value
> of
> yyyy? In other words how many of the dates fall within 2003, 2004, 2005,
> etc. Thanks.