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.