MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jerry on January 08, 2002 1:15 AM

I've got 4 columns of dates:
B is always bigger then A and D is always bigger then C.

So I've got two sets of date intervals: A-B and C-D
I want to know when (how long) the intervals overlap. I tried the IF AND formula, but I couldn't get it to work. What will?

Posted by Andy Gee on January 08, 2002 2:41 AM

Say you have cols a-d, C minus B should equal one month. If the dates overlap then it will return a negative number equal to the overlap.

a b c d 3
1/1 1/2 1/3 1/4 =c-b

I hope this helps.

Posted by Jerry on January 09, 2002 6:04 AM

I'm afraid it's a little more complex. I'll try to explain.

The first set of dates (columns A-B) are stops due to holidays. The second set of dates (C-D) are stops due to mechanical failures. Now I want to know when the failures are during the holiday, because then I put them down as holiday stops instead of mechanical failures.

Hope this is somewhat clearer.