Created attachment 192591 [details] Format MMMM, wrong month name Cell A1 contains a date in the format DD.MM.YYYY and I want to display the name of the month in cell B1. I use the function =MONTH() for this. If B1 is formatted as a decimal number, the month number is displayed correctly. However, if I format B1 as "MMMM", the month name is not correct. Example: A1 = "04.01.2024", B1 = "December" "January" in B1 would be correct. I use the German version of LibreOffice. It is therefore possible that I have not translated format specifications or formulas correctly.
Created attachment 192592 [details] Format as decimal number, month number is correct
Do not format a month number as month, but a date instead. e.g. in C2 simply have =A2 and apply the MMMM number format. A value of 1 would be the date serial number of nulldate+1 so 1899-12-30 + 1 = 1899-12-31 => December, a value of 2 the date serial number of nulldate+2 so 1899-12-30 + 2 = 1900-01-01 => January.