Check for Date Time & Day Overlap formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3360781%22%20slang%3D%22en-US%22%3ECheck%20for%20Date%20Time%20%26amp%3B%20Day%20Overlap%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3360781%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%3EI%20am%20trying%20to%20find%20a%20formula%20to%20check%20the%20%3C%2FSPAN%3EDate%2C%20Time%2C%20and%20Day%20Overlapping%20for%20different%20courses%20in%20excel.%20I%20have%20tried%20SUMPRODUCT%2C%20COUNTIF%2C%20and%20similar%20functions%20to%20get%20the%20desired%20output.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SS.PNG%22%20style%3D%22width%3A%20426px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370959iCAA30E6F20958AA4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SS.PNG%22%20alt%3D%22SS.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3360781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3361004%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20for%20Date%20Time%20%26amp%3B%20Day%20Overlap%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361004%22%20slang%3D%22en-US%22%3EHi%2C%20On%20ExcelJet%20I%20find%20an%20interesting%20suggestion%3A%20%3DMAX(MIN(end1%2Cend2)-MAX(start1%2Cstart2)%2B1%2C0)%20If%20that%20doesn't%20bring%20you%20further%2C%20please%20elaborate%20what%20you%20want%20to%20do%20with%20the%20overlap.%20Kind%20regards%20Hans%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

SS.PNG

1 Reply
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