Check for Date Time & Day Overlap formula

[RatinderSingh]

Hi 

I am trying to find a formula to check the Date, Time, and Day Overlapping for different courses in excel. I have tried SUMPRODUCT, COUNTIF, and similar functions to get the desired output.

[#2]

Hi, On ExcelJet I find an interesting suggestion: =MAX(MIN(end1,end2)-MAX(start1,start2)+1,0) If that doesn't bring you further, please elaborate what you want to do with the overlap. Kind regards Hans