I'm assming you want to compa

1/1/08 - 5/1/08 to 2/1/08 - 6/1/08
2/1/08 - 2/30/08 to 2/1/08 - 2/30/08

On Sheet2:

=MAX(0,MIN(B1,Sheet1!B1)-MAX(A1,Sheet1!A1)+1)0

Copy down as needed.


--
Biff
Microsoft Excel MVP


"Carolina Girl" wrote in message
...
This is probable very simple and I am just overlooking it. But can some
tell
me how to find out if a date range falls between or overlaps another date
range?? Tab 1 contains start and stop vacation dates, tab 2 contains start
and stop blackout dates. I need to list on Tab C2 if the persons vacation
is
in a blackout date or not.

Tab1
A B
1 Start End
2 1/1/08 5/1/08
3 2/1/08 2/30/08

Tab2
A B
1 Start End
2 2/1/08 6/1/08
3 2/1/08 2/30/08


Thanks in advance..