Bug 140891

Summary:	Function MONTH does not properly display the correct information
Product:	LibreOffice	Reporter:	Sean Bryan <sb8301450-misc>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED NOTABUG
Severity:	normal	CC:	79045_79045
Priority:	medium
Version:	7.0.4.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108827

Description Sean Bryan 2021-03-08 16:49:41 UTC

When executing function =MONTH(NOW())  the result should be "3", but, I get 
Jan-00.

The month today is March 2021.

Thank you.

Comment 1 Roman Kuznetsov 2021-03-08 19:23:21 UTC

No repro in

Version: 7.2.0.0.alpha0+ (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.