Overlapping working time period

[MPhuong]

Dear all,

I am working on the overlapping working time period, I manage to find out the number of days, months periods of overlapping but I need some help for identify the exactly those period,eliminate them and automatically replace with the the new date after that overlapping periods.

The data is something like this.

Original Time	New Time period after eliminating the overlapping
Company Name	Start	End	Start	End
Employer A	Sep-97	Aug-05	Sep-97	Aug-05
Employer B	Apr-01	Jul-17	Apr-01 Jul-07	Mar-06 Jul-07
Employer C	May-01	Jul-17	May-01 Jul-07	Mar-06 Jul-07
Employer D	Apr-06	Jun-07	Apr-06	Jun-07

<tbody>
</tbody>

Appreciate for all of your suggestions and helps.

Thank.

 

[MPhuong]

Dear all,

I am working on overlapping working time period, I manage to find out the number of days and months periods of overlapping but I need some help to identify exactly those period,eliminate them and automatically replace with the new date after that overlapping periods.

The data are something like this.

Original Time	New Time period after eliminating the overlapping
Company Name	Start	End	Start	End
Employer A	Sep-97	Aug-05	Sep-97	Aug-05
Employer B	Apr-01	Jul-17	Apr-01 Jul-07	Mar-06 Jul-07
Employer C	May-01	Jul-17	May-01 Jul-07	Mar-06 Jul-07
Employer D	Apr-06	Jun-07	Apr-06	Jun-07

<tbody>
</tbody>

Appreciate for all of your suggestions and helps.

Thank you.

P/S: Just wondering the VLookup function in this case