https://bugs.documentfoundation.org/show_bug.cgi?id=143947
Bug ID: 143947 Summary: Function DATE yields wrong year if input is only "year" Product: LibreOffice Version: 7.1.2.2 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: flavius.chir...@gmail.com When using the DATE function which requires inputs (Year;Month;Day), omitting one or two inputs (i.e. Month/Day or both) yields incorrect output. Is this by design? Explanation would help, otherwise it's a bug, no? Examples: =DATE(2006;;) -> 2005-11-30 incorrect / bug?! =DATE(2006;1;) -> 2005-12-31 incorrect / bug?! =DATE(2006;;1) -> 2005-12-01 incorrect / bug?! =DATE(2006;1;1) -> 2006-01-01 correct Reproducable: new document As usual, please link to duplicates or solutions etc., online search did however not easily find something. Thanks, Greets -- You are receiving this mail because: You are the assignee for the bug.