Absence Periods Calculation

Originally Posted by humdingaling

based on that criteria
i made some amendments to the formula
439 shows as 3 now

used column F again just so the formula looks neater to troubleshoot
if the final formula you can incorprate the weekend() bit into the if formula

Hi, one slight question

Is it possible to ignore the 'join if 1 and 5 are together' if days 1 and 5 have at least 5 days between them ?
For example, the first employee 88 is saying 1 period when it should be 2, because it is treating the last 2 absences (1 Nov 13 & 25 Nov 13 ) as linked due to both being day1 and day5, when in fact they are days apart. Does this make sense?