https://bugs.documentfoundation.org/show_bug.cgi?id=115300
Bug ID: 115300
Summary: date formula skips a month (same formula hasn't been
ok till today)
Product: LibreOffice
Version: 5.3.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have been using =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1)), which adds one month
to today's date. Has been working the last 6 or 8 months, but now it is
skipping February and shows March!
Steps to Reproduce:
1. =now()....in A1 And as today being Jan. 29
2.=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))This will skip a month and show March!
3.=MONTH(A1)This will show December!
Actual Results:
Above
Expected Results:
above
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0
--
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
