Hi Team,
Can someone help me in solving the flagging of overlapping dates.
I have attached one excel file where overlapping is done with a formula. i left the formula as is for your reference. I want to assign serial numbers for every overlapping instances.
If there are overlapping dates then that should be marked with serial number, if no overlapping occurs between dates blank should be returned. I'm struggling to get the desired output.
The result i need is mentioned in column F manually.
Note. For better understanding I have inserted blank row in between data. Please ignore blank rows.
Thanks for you help..
Can someone help me in solving the flagging of overlapping dates.
I have attached one excel file where overlapping is done with a formula. i left the formula as is for your reference. I want to assign serial numbers for every overlapping instances.
If there are overlapping dates then that should be marked with serial number, if no overlapping occurs between dates blank should be returned. I'm struggling to get the desired output.
The result i need is mentioned in column F manually.
Note. For better understanding I have inserted blank row in between data. Please ignore blank rows.
Thanks for you help..
Attachments
Last edited: