Well, with a little flexibility of counting for more than just years, you
could do the following:
=SUMPRODUCT(($A$2:$A$5001=firstdate)*($A$2:$A$500 1<=lastdate))

Hope this helps.
--
John C


"smcmoran" wrote:

I have a list of over 5000 birth dates i.e: 2/7/1975. I need to count the
number of times a cell has a date in a date range of years. For example I
need to know how many were born in the years 1927 thruogh 1937.

Scott