[Libreoffice-bugs] [Bug 124231] Day function for creating date is off by one

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124231

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
To add to this, DAY(21) is not only unnecessary, it's wrong. DAY() calculates
the day of month of the date serial number (days since null date) passed as
argument. The date serial number 21 here happens to represent 1900-01-21 in
Excel so there's no visible difference in the result, but 1900-01-20 in Calc
because of Excel's leap year bug for which Calc shifts the null date.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190423/539ee955/attachment-0001.html>