VAN
=ALS(IS.EVEN(WEEKNUMMER($C6));ALS(WEEKDAG($B6;2 )=1;$D$172;ALS(WEEKDAG($B6;2 )=2;$D$177;ALS(WEEKDAG($B6;2 )=3;$D$182;ALS(WEEKDAG($B6;2 )=4;$D$187;ALS(WEEKDAG($B6;2 )=5;$D$192;ALS(WEEKDAG($B6;2 )=6;$D$198;ALS(WEEKDAG($B6;2 )=7;$D$199)))))));ALS(WEEKDAG($B6;2 )=1;$D$171;ALS(WEEKDAG($B6;2 )=2;$D$176;ALS(WEEKDAG($B6;2 )=3;$D$181;ALS(WEEKDAG($B6;2 )=4;$D$186;ALS(WEEKDAG($B6;2 )=5;$D$191;ALS(WEEKDAG($B6;2 )=6;$D$198;ALS(WEEKDAG($B6;2 )=7;$D$199))))))))


TOT
=ALS(IS.EVEN(WEEKNUMMER($C6));ALS(WEEKDAG($B6;2 )=1;$E$172;ALS(WEEKDAG($B6;2 )=2;$E$177;ALS(WEEKDAG($B6;2 )=3;$E$182;ALS(WEEKDAG($B6;2 )=4;$E$187;ALS(WEEKDAG($B6;2 )=5;$E$192;ALS(WEEKDAG($B6;2 )=6;$E$198;ALS(WEEKDAG($B6;2 )=7;$E$199)))))));ALS(WEEKDAG($B6;2 )=1;$E$171;ALS(WEEKDAG($B6;2 )=2;$E$176;ALS(WEEKDAG($B6;2 )=3;$E$181;ALS(WEEKDAG($B6;2 )=4;$E$186;ALS(WEEKDAG($B6;2 )=5;$E$191;ALS(WEEKDAG($B6;2 )=6;$E$198;ALS(WEEKDAG($B6;2 )=7;$E$199))))))))

PAUZE
=ALS(IS.EVEN(WEEKNUMMER($C6));ALS(WEEKDAG($B6;2 )=1;$C$172;ALS(WEEKDAG($B6;2 )=2;$C$177;ALS(WEEKDAG($B6;2 )=3;$C$182;ALS(WEEKDAG($B6;2 )=4;$C$187;ALS(WEEKDAG($B6;2 )=5;$C$192;ALS(WEEKDAG($B6;2 )=6;$C$198;ALS(WEEKDAG($B6;2 )=7;$C$199)))))));ALS(WEEKDAG($B6;2 )=1;$C$171;ALS(WEEKDAG($B6;2 )=2;$C$176;ALS(WEEKDAG($B6;2 )=3;$C$181;ALS(WEEKDAG($B6;2 )=4;$C$186;ALS(WEEKDAG($B6;2 )=5;$C$191;ALS(WEEKDAG($B6;2 )=6;$C$198;ALS(WEEKDAG($B6;2 )=7;$C$199))))))))

Het weeknummer bepalen:
=INTEGER((B96-DATUM(JAAR(B96-WEEKDAG(B96-1)+4);1;3)+WEEKDAG(DATUM(JAAR(B96-WEEKDAG(B96-1)+4);1;3))+5)/7)