Zelle | Formel |
C8 | =C9 |
D8 | =C8+1 |
E8 | =D8+1 |
F8 | =E8+1 |
G8 | =F8+1 |
H8 | =G8+1 |
I8 | =H8+1 |
J8 | =I8+1 |
K8 | =J8+1 |
L8 | =K8+1 |
M8 | =L8+1 |
N8 | =M8+1 |
O8 | =N8+1 |
P8 | =O8+1 |
Q8 | =P8+1 |
R8 | =Q8+1 |
S8 | =R8+1 |
T8 | =S8+1 |
U8 | =T8+1 |
V8 | =U8+1 |
W8 | =V8+1 |
X8 | =W8+1 |
Y8 | =X8+1 |
Z8 | =Y8+1 |
AA8 | =Z8+1 |
AB8 | =AA8+1 |
AC8 | =AB8+1 |
AD8 | =AC8+1 |
AE8 | =AD8+1 |
AF8 | =AE8+1 |
AG8 | =AF8+1 |
AH8 | =AG8+1 |
B9 | =DATUM($B$1;ZEILE(B1);1) |
C9 | =DATUM($B$1;ZEILE(B1);1) |
D9 | =C9+1 |
E9 | =D9+1 |
F9 | =E9+1 |
G9 | =F9+1 |
H9 | =G9+1 |
I9 | =H9+1 |
J9 | =I9+1 |
K9 | =J9+1 |
L9 | =K9+1 |
M9 | =L9+1 |
N9 | =M9+1 |
O9 | =N9+1 |
P9 | =O9+1 |
Q9 | =P9+1 |
R9 | =Q9+1 |
S9 | =R9+1 |
T9 | =S9+1 |
U9 | =T9+1 |
V9 | =U9+1 |
W9 | =V9+1 |
X9 | =W9+1 |
Y9 | =X9+1 |
Z9 | =Y9+1 |
AA9 | =Z9+1 |
AB9 | =AA9+1 |
AC9 | =AB9+1 |
AD9 | =AC9+1 |
AE9 | =AD9+1 |
AF9 | =AE9+1 |
AG9 | =AF9+1 |
B10 | =DATUM($B$1;ZEILE(B2);1) |
C10 | =WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(C9);AG9+1;"") |
D10 | =WENN(C10<>"";C10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(D9);AH9+1;"")) |
E10 | =WENN(D10<>"";D10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(E9);AI9+1;"")) |
F10 | =WENN(E10<>"";E10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(F9);AJ9+1;"")) |
G10 | =WENN(F10<>"";F10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(G9);AK9+1;"")) |
H10 | =WENN(G10<>"";G10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(H9);AL9+1;"")) |
I10 | =WENN(H10<>"";H10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(I9);AM9+1;"")) |
J10 | =WENN(I10<>"";I10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(J9);AN9+1;"")) |
K10 | =WENN(J10<>"";J10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(K9);AO9+1;"")) |
L10 | =WENN(K10<>"";K10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(L9);AP9+1;"")) |
M10 | =WENN(L10<>"";L10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(M9);AQ9+1;"")) |
N10 | =WENN(M10<>"";M10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(N9);AR9+1;"")) |
O10 | =WENN(N10<>"";N10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(O9);AS9+1;"")) |
P10 | =WENN(O10<>"";O10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(P9);AT9+1;"")) |
Q10 | =WENN(P10<>"";P10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(Q9);AU9+1;"")) |
R10 | =WENN(Q10<>"";Q10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(R9);AV9+1;"")) |
S10 | =WENN(R10<>"";R10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(S9);AW9+1;"")) |
T10 | =WENN(S10<>"";S10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(T9);AX9+1;"")) |
U10 | =WENN(T10<>"";T10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(U9);AY9+1;"")) |
V10 | =WENN(U10<>"";U10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(V9);AZ9+1;"")) |
W10 | =WENN(V10<>"";V10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(W9);BA9+1;"")) |
X10 | =WENN(W10<>"";W10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(X9);BB9+1;"")) |
Y10 | =WENN(X10<>"";X10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(Y9);BC9+1;"")) |
Z10 | =WENN(Y10<>"";Y10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(Z9);BD9+1;"")) |
AA10 | =WENN(Z10<>"";Z10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AA9);BE9+1;"")) |
AB10 | =WENN(AA10<>"";AA10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AB9);BF9+1;"")) |
AC10 | =WENN(AB10<>"";AB10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AC9);BG9+1;"")) |
AD10 | =WENN(AC10<>"";AC10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AD9);BH9+1;"")) |
AE10 | =WENN(AD10<>"";AD10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AE9);BI9+1;"")) |
AF10 | =WENN(AE10<>"";AE10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AF9);BJ9+1;"")) |
AG10 | =WENN(AF10<>"";AF10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AG9);BK9+1;"")) |
AH10 | =WENN(AG10<>"";AG10+1;WENN(WOCHENTAG($AG$9+1)=WOCHENTAG(AH9);BL9+1;"")) |