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???
--
Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."
--
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