https://bugs.documentfoundation.org/show_bug.cgi?id=155438
--- Comment #3 from m.a.riosv <miguelange...@libreoffice.org> --- This is LibreOffice being more strict about some calculations. Sure you can, in D10: =IF(ROUND(C10;4)=0;0;DATE(MOD(IF(MONTH(A9)>=12;(YEAR(A9)-1900)+1;(YEAR(A9)-1900));100);IF(MONTH(A9)=12;1;MONTH(A9)+1);DAY(A9))) It is using the MOD() function to get the rest from 100, the year with two digits. But in any case inside formulas four digits should be used, to avoid problems. =IF(ROUND(C10;4)=0;0;DATE(IF(MONTH(A9)>=12;YEAR(A9)+1;YEAR(A9));IF(MONTH(A9)=12;1;MONTH(A9)+1);DAY(A9))) which makes the formula even more simple. -- You are receiving this mail because: You are the assignee for the bug.
