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:
>
>
: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
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
07/12/17
Jul
08/13/17
Aug
09/14/17
Sep
10/16/17
Oct
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
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")
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
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
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
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
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
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???
12 matches
Mail list logo