https://bugs.documentfoundation.org/show_bug.cgi?id=151183
--- Comment #1 from Mike Kaganski <[email protected]> --- OTOH, what Excel gives is also confusing: why "year 0" must mean 1900? If at all, DATE(6;1;1) should give 0006-01-01, not something related to HOST-NULL-DATE. Maybe use of HOST-NULL-YEAR here is more substantiated. The question arose in https://forumooo.ru/index.php?topic=9386.msg63874, about the Excel formula that stopped working for the reporter: =A1+DATE(6;1;-2) where A1 had a date, to which the reporter wanted to add 6 years. The formula is conceptually wrong, though (adding two serial dates makes no sense), so WONTFIX/NOTABUG is a valid resolution. -- You are receiving this mail because: You are the assignee for the bug.
