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))