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
<TBODY>
</TBODY>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
| Emp ID | Forename | Surname | Start Date | End Date |
| 121 | John | Dodge | 16/05/14 | 16/05/14 |
| 121 | John | Dodge | 19/05/14 | 19/05/14 |
| 154 | Stacey | Dash | 12/02/14 | 12/02/14 |
<TBODY>
</TBODY>
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
