Hello, Day "1" is December 31, 1899 (at least, this is what I get when I display "1" with a YYYY-MM-DD format): this is why 'TEXT(MONTH(NOW()),"MMM")"' gives "December". To get something like this to come out consistently, I always use a formula like this:
=TEXT(DATE(1900;MONTH(NOW());1);"MMM") [basically asking for the month of Jan 1, 1900] In this case, the formula is not influenced by the date encoding scheme and will yield the desired result. I hope this helps. Rémy Gauthier. Le vendredi 13 janvier 2017 à 15:17 -0500, Tanstaafl a écrit : > > If it is its been there a long time, because I first encountered this a > loooong time ago (I finally decided to ask about it). > > Would appreciate someone confirming I'm not just crazy, and it should > work as I'm expecting. > > > On Fri Jan 13 2017 15:12:50 GMT-0500 (Eastern Standard Time), Joe Conner > > <[email protected]> wrote: > > Bug??? > > > > On 01/13/2017 12:05 PM, Tanstaafl wrote: > > > Ok, this is really driving me nuts... > > > > > > Given: > > > > > > =MONTH(NOW()) > > > results in the number of the current month (1, for January) > > > > > > I want to simply translate this to the monthname, so I used: > > > > > > =TEXT(MONTH(NOW()),"MMM") > > > > > > this almost gives me what I want, but it results in "Dec', instead of > > > "Jan" - WTF??? > > > > > > Changing it to: > > > > > > =TEXT(MONTH(NOW())+1,"MMM") > > > gives me "Jan", which is what I want. > > > > > > Why do I have to add a '1' to it??? > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
