Ešte som zabudol, že existuje funkcia INT, takže vzorce by mohli vyzerať o malý kúsok jednoduchšie:
Pre B1:
=DAY(A1)+MONTH(A1)+INT(YEAR(A1)/1000)+INT(MOD(YEAR(A1);1000)/100)+INT(MOD(YEAR(A1);100)/10)+MOD(YEAR(A1);10)Pre C1:
=IF(B1<23;B1;INT(B1/10)+MOD(B1;10))Výsledný vzorec:
=IF(DAY(A1)+MONTH(A1)+INT(YEAR(A1)/1000)+INT(MOD(YEAR(A1);1000)/100)+INT(MOD(YEAR(A1);100)/10)+MOD(YEAR(A1);10)<23;DAY(A1)+MONTH(A1)+INT(YEAR(A1)/1000)+INT(MOD(YEAR(A1);1000)/100)+INT(MOD(YEAR(A1);100)/10)+MOD(YEAR(A1);10);INT((DAY(A1)+MONTH(A1)+INT(YEAR(A1)/1000)+INT(MOD(YEAR(A1);1000)/100)+INT(MOD(YEAR(A1);100)/10)+MOD(YEAR(A1);10))/10)+MOD(DAY(A1)+MONTH(A1)+INT(YEAR(A1)/1000)+INT(MOD(YEAR(A1);1000)/100)+INT(MOD(YEAR(A1);100)/10)+MOD(YEAR(A1);10);10))