[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

Aron Budea <baron at caesar.elte.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86-64 (AMD64)              |All
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |baron at caesar.elte.hu
         Resolution|---                         |WONTFIX
                 OS|Linux (All)                 |All

--- Comment #3 from Aron Budea <baron at caesar.elte.hu> ---
This is because of Calc's starting date counting being different from Excel's
to account for Excel's 1900 leap year bug. For details please see bug 44453
comment 3.

However, your usage of DAY(...) function is unnecessary, instead of DAY(21) you
should just have 21 in there.

-- 
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/22618a56/attachment.html>