[Libreoffice-bugs] [Bug 115300] New: date formula skips a month (same formula hasn' t been ok till today)

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: mclean8414 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180129/efc26190/attachment.html>