https://bugs.documentfoundation.org/show_bug.cgi?id=140891
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #2 from Eike Rathke <[email protected]> ---
The MONTH() result *is* 3 but you can't format that result as date and expect
it would display March, same as with any number 3. Instead, it displays the
date for "3 days since null date", which for the null date 1899-12-30 happens
to be 1900-01-02 so for your MMM-YY format you get Jan-00.
Just use =NOW() and format it to MMM-YY if that is what you want.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
