Re: [libreoffice-users] Calculating MONTHNAME

2017-01-16 Thread Tanstaafl
Worked perfectly, thanks Tony! On Fri Jan 13 2017 15:15:15 GMT-0500 (Eastern Standard Time), Tony Arnold 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: > >

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-14 Thread Tony Arnold
:00) To: Tanstaafl <tansta...@libertytrek.org>, users@global.libreoffice.org, Remy Gauthier <remygauth...@yahoo.com> Subject: 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

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-14 Thread Brian Barker
At 15:05 13/01/2017 -0500, Charles Marcus 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

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-14 Thread Kruno
07/12/17 Jul 08/13/17 Aug 09/14/17 Sep 10/16/17 Oct

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Michael D. Setzer II
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: Sub

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Remy Gauthier
Hello, Day "1" is December 31, 1899 (at least, this is what I get when I display "1" with a -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")

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Kruno
13.01.2017 u 21:28, Kruno je napisao/la: 13.01.2017 u 21:17, Tanstaafl je napisao/la: If it is its been there a long time, because I first encountered this a lng time ago (I finally decided to ask about it). Would appreciate someone confirming I'm not just crazy, and it should work as

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Tony Arnold
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

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Kruno
13.01.2017 u 21:17, Tanstaafl je napisao/la: If it is its been there a long time, because I first encountered this a lng 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

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Tanstaafl
If it is its been there a long time, because I first encountered this a lng 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

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Joe Conner
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

[libreoffice-users] Calculating MONTHNAME

2017-01-13 Thread Tanstaafl
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???