Hi,

How about:

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

Regards,
KL


"LyleB_Austin" wrote in message
...
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.