https://bugs.documentfoundation.org/show_bug.cgi?id=158694
Bug ID: 158694 Summary: TEXT() function is not formatting months correctly. Product: LibreOffice Version: 7.6.4.1 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: stephendrak...@gmail.com Description: I want to display the current month name from a date-formatted cell. I am using the TEXT function as follows: =TEXT(month(cell-id),"MMMM"). Cell-id is the cell containing the date. Steps to Reproduce: 1.Enter 1/1/23 in cell A1, 1/2/23 in A2, 1/3/23 in A3, etc until 1/12/23 in A12. 2.Enter =MONTH(A1) in B1, =MONTH(A2) in B2, and copy down to MONTH(A12) in B12. 3.Enter =TEXT(B1,"MMMM") in C1. Copy down to and including C12. Actual Results: C1 shows "December". C2 - C12 all show "January". Expected Results: C1 should show January, C2 February, C3 March and so on down to C12 which should show December. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.