Description: When formatting month with MMM (jan, feb, mar etc) or MMMM (january, february etc) results on wrong text. 2015-01-01, 2016-01-01, 2017-01-01 etc returns december while the other months are returned as january. This happens if you have extracted the month with the function MONTH(). Steps to Reproduce: 1.Create a list with dates from for example 2013-01-01, 2013-02-01, 2013-03-01 etc 2.Extract month from the liste of dates with the function MONTH() 3.Format the extracted list with MM or MMM to create the result. Actual Results: Dec, Jan, Jan Expected Results: Jan, Feb, Mar Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36
The underlying displayed values from the Function MONTH are correct month value 1, 2, 3, 4, 5, 6, etc.
Created attachment 128394 [details] Sample file I think there is not such bug. When you use the MONTH() function you gets only the month number 1-12. The format for dates only works properly on cells with a date value. So to format for getting the text month you can't extract the month. Please take a look to the attache file.