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€¦.