Re: [libreoffice-users] Calculating MONTHNAME

Try =text(now(),"MMM")

Tony.
On Fri, 2017-01-13 at 15:05 -0500, 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???



--

Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, Kilburn 
Building | The University of Manchester | Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 
0039

-- 
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