Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

At 08:52 28/01/2018 +0100, Johnny Rosenberg wrote:
For some strange reason you need to make sure you enter valid values for month and day. In Excel (which sucks in most aspects, but I have to use it at work) you can do things like DateSerial(2017, 13, 59), which returns the date value for 2018-02-28, but that seems to throw an error in LibreOffice. That's odd, or at least primitive, I think. It would be very convenient not having to think about those boundaries, just increase the month number and it just works. Maybe I should file a bug report or enhancement request about thatÂ…

Does =DATE(2017;13;59) not give 2018-02-28 for you?

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.