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.
[TABLE="width: 650"]
<tbody>[TR]
[TD="colspan: 3"]Original Time[/TD]
[TD="colspan: 2"]New Time period after eliminating the overlapping[/TD]
[/TR]
[TR]
[TD]Company Name[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[/TR]
[TR]
[TD] Employer A[/TD]
[TD="align: right"]Sep-97[/TD]
[TD="align: right"]Aug-05[/TD]
[TD]Sep-97[/TD]
[TD]Aug-05[/TD]
[/TR]
[TR]
[TD] Employer B[/TD]
[TD]Apr-01[/TD]
[TD]Jul-17[/TD]
[TD]Apr-01
Jul-07[/TD]
[TD]Mar-06
Jul-07[/TD]
[/TR]
[TR]
[TD] Employer C[/TD]
[TD]May-01[/TD]
[TD]Jul-17[/TD]
[TD]May-01
Jul-07[/TD]
[TD]Mar-06
Jul-07[/TD]
[/TR]
[TR]
[TD] Employer D[/TD]
[TD="align: right"]Apr-06[/TD]
[TD="align: right"]Jun-07[/TD]
[TD]Apr-06[/TD]
[TD]Jun-07[/TD]
[/TR]
</tbody>[/TABLE]

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.
[TABLE="width: 650"]
<tbody>[TR]
[TD="colspan: 3"]Original Time[/TD]
[TD="colspan: 2"]New Time period after eliminating the overlapping[/TD]
[/TR]
[TR]
[TD]Company Name[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[/TR]
[TR]
[TD] Employer A[/TD]
[TD="align: right"]Sep-97[/TD]
[TD="align: right"]Aug-05[/TD]
[TD]Sep-97[/TD]
[TD]Aug-05[/TD]
[/TR]
[TR]
[TD] Employer B[/TD]
[TD]Apr-01[/TD]
[TD]Jul-17[/TD]
[TD]Apr-01
Jul-07[/TD]
[TD]Mar-06
Jul-07[/TD]
[/TR]
[TR]
[TD] Employer C[/TD]
[TD]May-01[/TD]
[TD]Jul-17[/TD]
[TD]May-01
Jul-07[/TD]
[TD]Mar-06
Jul-07[/TD]
[/TR]
[TR]
[TD] Employer D[/TD]
[TD="align: right"]Apr-06[/TD]
[TD="align: right"]Jun-07[/TD]
[TD]Apr-06[/TD]
[TD]Jun-07[/TD]
[/TR]
</tbody>[/TABLE]

Appreciate for all of your suggestions and helps.

Thank you.

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