Tak zrovna takto by som to urcite nerobil, preto som mu napisal o funkcii MOD aby to nerobil jak pako :)
QUOTIENT(YEAR(A1),1000) + QUOTIENT(MOD(YEAR(A1),1000),100) + QUOTIENT(MOD(YEAR(A1),100),10) + MOD(YEAR(A1),10) + MONTH(A1) + DAY(A1)