Re: [libreoffice-users] Calculating MONTHNAME

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