=QUOTIENT(YEAR(A1);1000)+QUOTIENT(MOD(YEAR(A1);1000);100)+QUOTIENT(MOD(YEAR(A1);100);10)+MOD(YEAR(A1);10)+MONTH(A1)+DAY(A1)
nefunguje?P.S> vyhodil som este preistotu medzery, neviem co tam mrkvosoft este moze pindat. V openoffice to funguje (aj s medzerami).