| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Help with the FIND function | Excel Worksheet Functions | |||
| Worksheet Function - Find? | Excel Worksheet Functions | |||
| find calculation function | Excel Worksheet Functions | |||
| how to get the intersect cell data out using vba or function | Excel Worksheet Functions | |||
Threaded Mode
