Absence Periods Calculation

Originally Posted by humdingaling

hmm missing something
439 i still get 4

439 17-Feb-14 21-Feb-14 439
439 4-Mar-14 24-Mar-14
439 25-Mar-14 28-Mar-14 439
439 31-Mar-14 31-Mar-14
439 1-Apr-14 4-Apr-14 439
439 7-Apr-14 11-Apr-14
439 12-Apr-14 17-Apr-14
439 21-Apr-14 25-Apr-14 439

hi, thought i replied to this thread.
28 Mar and 31 Mar are linked as they are both 1 and 5
4 Apr and 7 Apr are linked as they are both 5 and 1
So, dates are 17 Feb-21Feb, 4 Mar-17 Apr and 21 Apr-25 Apr = 3 periods