My hunch would be that the source "dates" aren't real dates recognized by Excel

But your expression should be, to be precise:
=SUMPRODUCT((RQTS=$A2)*(RQTS<=$B2))

Alternatively, I'd use this expression
when capturing dates which fall within a certain month/year:
=SUMPRODUCT(--(TEXT(RQTS,"mmmyy")="Aug08"))

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---


"Stuck" wrote:

I define a range as a name (RQTS). Within that range is a set of random
dates. I would like to know if the dates are greater than one date and less
than another date. For instance:

A2 = 8/1/08
B2 = 8/31/08
C2:C500 = Defined name (RQTS)--random set of dates. Here is my formula. It
is returning 0 every time. What am I doing wrong? There should be 6
instances that are counted.

=SUMPRODUCT((RQTS$A2)*(RQTS<$B2))