• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find the overlapping dates using criteria


New Member
Hi friends, I'm in need of help. Can some of you spare some time for excel formula. I tried for two days but I haven't find the desired output. I have mentioned the procedure in attached excel on right side of the sheet.

Thanks in advance.

Sorry for the inconvenience caused.



Excel Ninja
Okay - overlapping dates ... no matter of times.
Where is Your criterian?
Where is Your sample result?
... Is Your right side total result? ... where comes Check#, 'Status', 'Yes/No' and Comments?


New Member
Hi sir, sorry for the late reply. I have attached the new file for your understanding. Kindly please check once the new attached file. My sincerior apologies for the late reply.