Absence Periods Calculation

dele...dont usually proceed with anything if people stop responding
it usually means they figured it out and plain moved on

also as i really don't know exactly what you want i didnt know how to proceed

i added some lines and a table to your original sheet
please indicate the lines you want skipped?

6 and 7 = Saturday and Sunday respectively