SSP calculation to Look up between a range of dates with linked periods

1.

=IF(P18=1;28*7;IF(J19>3;Q19-J19;Q19))

into Q18 and copied upwards should do it.

What if you had several sequential 3 day sick leaves? If the ssp should not deduct with them then that's okay. Things might get tricky (more ifs I guess :D) if from the 4th day - the first day of second absence - ssp ought to be deducted while 4 being the smallest possible number of deducted days.

2. Hmmm, well, as I put a seed of 28 weeks into Q19, maybe the easiest way to get this done is to find out the remaining ssp days at the beginning of the year and for e.g. put that number into R19 and change Q19 into 28*7-R19?