Bug 140891 - Function MONTH does not properly display the correct information
Summary: Function MONTH does not properly display the correct information
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2021-03-08 16:49 UTC by Sean Bryan
Modified: 2021-03-08 20:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Sean Bryan 2021-03-08 16:49:41 UTC
When executing function =MONTH(NOW())  the result should be "3", but, I get 

The month today is March 2021.

Thank you.
Comment 1 Roman Kuznetsov 2021-03-08 19:23:21 UTC
No repro in

Version: (x64) / LibreOffice Community
Build ID: d8ed3bda462b351d2b98ec57cfdb879e0eec0010
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

I got 3 as expected
Comment 2 Eike Rathke 2021-03-08 20:03:49 UTC
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.