Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"smcmoran" wrote in message
...
Thank you, That worked perfectly and very simply. I was trying to
complicate
the formula too much.

"Don Guillett" wrote:

try
=sumproduct((year(a2:a5000)=1927)*(year(a2:a5000) <=1937))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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