count date ranges

[Ann]

look in column A for date between 5/19 and 5/22, for each, go to column B and
see if the date falls within the range of 5/19 and 5/22, and give a total of
the dates which are outside of these date ranges.
tia

 

[Max]

One guess, maybe you meant something like this:
=SUMPRODUCT((A2:A10<>"")*(B2:B10<>""))-SUMPRODUCT((A2:A10>=--"19May2008")*(A2:A10<=--"22May2008")*(B2:B10>=--"19May2008")*(B2:B10<=--"22May2008"))

 

[Ann]

i have this:
=SUMPRODUCT((I6:I402<>"")*(M6:M402<>""))-SUMPRODUCT((I6:I402>=--A1)*(I6:I402<=--A2)*(M6:M402>=--A1)*(M6:M402<=--A2))

this is giving me a much larger # than i expect. i want it to search M for
dates within 5/19 and 5/22, compare them to dates in I with the same dates,
and return a result, if the date in M > date in I. apologies if i worded it
wrong.

 

[Max]

Can you upload your sample file/data using a free filehost,
post a link to it here

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" generated after you upload,
then paste it here