Absence Periods Calculation - Excel 2010

[dele1]

Can you help, I have an absence sheet which shows each employee number and each period of absence - start and end date, in the following columns
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Emp ID[/TD]
[TD]Forename[/TD]
[TD]Surname[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]121[/TD]
[TD]John[/TD]
[TD]Dodge[/TD]
[TD]16/05/14[/TD]
[TD]16/05/14[/TD]
[/TR]
[TR]
[TD]121[/TD]
[TD]John[/TD]
[TD]Dodge[/TD]
[TD]19/05/14[/TD]
[TD]19/05/14[/TD]
[/TR]
[TR]
[TD]154[/TD]
[TD]Stacey[/TD]
[TD]Dash[/TD]
[TD]12/02/14[/TD]
[TD]12/02/14[/TD]
[/TR]
</TBODY>[/TABLE]
There is multiple rows of dates for each employee as its the last 12 months absences.

I need a formulae to put at the end of each row to show if each date is linked or not, if its linked its treated as 1 absence, it would need to ignore weekends so any day before or after is classed as linked. This would then need to restart at the next employee ID

Any help is appreciated​