Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date ranges
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€¦. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Using Date ranges | Excel Discussion (Misc queries) | |||
Date ranges | Excel Worksheet Functions | |||
compare date to various date ranges and sum value | Excel Worksheet Functions | |||
If then Date Ranges | Excel Worksheet Functions | |||
sum of date ranges | Excel Worksheet Functions |