Worked perfectly, thanks Tony!
On Fri Jan 13 2017 15:15:15 GMT-0500 (Eastern Standard Time), Tony Arnold <tony.arn...@manchester.ac.uk> wrote: > 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+unsubscr...@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