Hi,

MONTH(C2:C73)<=12312008

After the equal to sign, shouldn't there be a number (from 1-12) indicating
the month.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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