| Home |
| Search |
| Today's Posts |
|
#11
|
|||
|
|||
Actually you do need to check for <= instead of just < beacause if one of the
periods ends at the same date as the start of the other the < check would be false . "Harlan Grove" wrote: "KL" wrote... Your formula can be further reduced to: =AND(Start2<=End1,Start1<=End2) .... Technically this wouldn't be overlap is either but not both conditions were TRUE due to exact equality. Drop the equal signs |
| 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
