| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
Hello, I need a function which allows me to enter the start and end dates
for two date-periods, then returns 'True' if there is any crossover (intersection) between the two periods. In simple terms if there is any day (or days) which appears in both periods. Can I do this with worksheet functions? or do I need VBA? Very grateful for any tips on how I code it. Sara |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a value at an intersection? | Excel Discussion (Misc queries) | |||
| I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
| Use intersection of column and TWO ranges in formula? | Excel Programming | |||
| Find intersection point using lables? | Excel Programming | |||
| Find Intersection | Excel Programming | |||
Threaded Mode
