I've already posted the solution. Just remove the call to month and do. =text (now (),"MMM")
Regards, Tony. Sent from my Samsung device -------- Original message -------- From: "Michael D. Setzer II" <[email protected]> Date: 14/01/2017 07:57 (GMT+00:00) To: Tanstaafl <[email protected]>, [email protected], Remy Gauthier <[email protected]> Subject: Re: [libreoffice-users] Calculating MONTHNAME Think the issue is that with "MMM", it treats the number as a date value instead of as being a month, so that 1 would result in December, and 2-12 result in January. So, the text option with month() doesn't seem to work at all, since the values don't match. Here is using choose to get what I think. Longer formula, but it seems to work, and would allow you do choose what exact format you want for each month. Number '=CHOOSE(MONTH(A4),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") 1 Dec 2 Jan 3 Jan 4 Jan 5 Jan 6 Jan 7 Jan 8 Jan 9 Jan 10 Jan 11 Jan 12 Jan Dates '=CHOOSE(MONTH(A4),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") 01/01/17 Jan 02/02/17 Feb 03/06/17 Mar 04/07/17 Apr 05/09/17 May 06/10/17 Jun 07/12/17 Jul 08/13/17 Aug 09/14/17 Sep 10/16/17 Oct 11/17/17 Nov 12/19/17 Dec On 13 Jan 2017 at 18:12, Remy Gauthier wrote: Subject: Re: [libreoffice-users] Calculating MONTHNAME From: Remy Gauthier <[email protected]> To: Tanstaafl <[email protected]>, [email protected] Date sent: Fri, 13 Jan 2017 18:12:39 -0500 > 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 -- 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 -- 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
