• 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

    Hui...

  • 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

RSHA

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.
 

Attachments

  • Main File.xlsx
    39.1 KB · Views: 8
RSHA
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?
 
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.
 

Attachments

  • vletm.xlsx
    89 KB · Views: 10
Hi Sir,

Sorry for the inconvenience caused. I already explained it clearly in attached excel file, based on your questions in the second reply. I don't know where you are facing problem. Please leave it.

Thanks
 
Last edited:
RSHA
How many overlapping dates there should be?
Your given 'raw data' should have same layout.
Questions are waiting for answers,
seems that You don't have time to focus.
 
Back
Top