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 <remygauthier@yahoo.com>
To:                     Tanstaafl <tanstaafl@libertytrek.org>, 
users@global.libreoffice.org
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
> > > <joeconner2007@gmail.com> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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