Forum Discussion

RatinderSingh's avatar
RatinderSingh
Copper Contributor
May 11, 2022

Check for Date Time & Day Overlap formula

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.

excel

1 Reply

  • hansleroy's avatar
    hansleroy
    Iron Contributor
    May 11, 2022
    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

Resources