https://bugs.documentfoundation.org/show_bug.cgi?id=146235
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Mike Kaganski <[email protected]> --- This is not a bug. MONTH [1] returns an integer between 1 and 12, that indicates a month number. So the return of MONTH is *not* a date. Format string "MMMM" [2] is a Date format, which means that the value passed to TEXT is a *date*. So the number "2" obtained from MONTH("2022-02-01") goes to TEXT and treated as a serial date (i.e., number of days since epoch - typically 1899-12-30). The 2nd day since then is 1900-01-01, which was on January, which you correctly get. The correct way of using TEXT with "MMMM" is: 3) Set C1 to =TEXT(B1;"MMMM") [1] https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_month.html?DbPAR=CALC#bm_id3149936 [2] https://help.libreoffice.org/7.2/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN -- You are receiving this mail because: You are the assignee for the bug.
