https://bugs.documentfoundation.org/show_bug.cgi?id=104400
GerardF <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
Resolution|--- |NOTABUG
--- Comment #2 from GerardF <[email protected]> ---
No bug here.
Format cell as standard and you will get expexted result.
A6 contains date July 31th of 2016,
C6 contains =DAY(A6),
result of C6 formula is 31.
Format of C6 cell is "DD", so it returns the day of the 31 days after date
origin which is set to 1899-12-30 in Calc. "1899-12-30"+31 → 1900-01-30
DAY("1900-01-30") = 30
You get 31 in Excel because Excel start one days later due that they
incorrectly considers 1900 as a leap year.
--
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
