count date ranges
 

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

count date ranges
 

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"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ann" wrote:
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

count date ranges
 

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.

count date ranges
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ann" wrote in message
...
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.