What if you wanted to look at specific quarter (i.e. a range of months within
a year)? I tried using
=SUMPRODUCT(((C2:C73)=01012008)*(MONTH(C2:C73)<=1 2312008))
with and without "month" and I got a zero, so clearly, I am not sure of the
format for the dates.
"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