Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index




14.01.2017 u 08:55, Michael D. Setzer II je napisao/la:
Think the issue is that with "MMM", it treats the number as a date value
instead of as being a month, so that 1 would result in December, and 2-12
result in January.

So, the text option with month() doesn't seem to work at all, since the values
don't match. Here is using choose to get what I think. Longer formula, but it
seems to work, and would allow you do choose what exact format you want
for each month.


We all tried to to pass integer value (result of MONTH()) to a TEXT() function which interpreted integer as number of days. Passing _date_ value does the job.

In documentation, MONTH() returns integer, and integer can not be treated as date data type, it just a plain number.

Tony's suggestion is correct - it passes date value (data type) to TEXT() function which calculates number of days passed since 1899-31-12 till now and returns correct result formated as "MMM".

So

= TEXT(NOW(), "MMM")

since OP wants it with NOW(), and Remy's suggestion seams longish now.

We were using TEXT() function wrong.




Number
'=CHOOSE(MONTH(A4),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

                                                                    1
Dec

                                                                    2
Jan

                                                                    3
Jan

                                                                    4
Jan

                                                                    5
Jan

                                                                    6
Jan

                                                                    7
Jan

                                                                    8
Jan

                                                                    9
Jan

                                                                   10
Jan

                                                                   11
Jan

                                                                   12
Jan

Dates
'=CHOOSE(MONTH(A4),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

                                                             01/01/17
Jan

                                                             02/02/17
Feb

                                                             03/06/17
Mar

                                                             04/07/17
Apr

                                                             05/09/17
May

                                                             06/10/17
Jun

                                                             07/12/17
Jul

                                                             08/13/17
Aug

                                                             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:

Subject:                Re: [libreoffice-users] Calculating MONTHNAME
From:                   Remy Gauthier <remygauthier@yahoo.com>
To:                     Tanstaafl <tanstaafl@libertytrek.org>,
users@global.libreoffice.org
Date sent:              Fri, 13 Jan 2017 18:12:39 -0500

Hello,

Day "1" is December 31, 1899 (at least, this is what I get when I
display "1" with a YYYY-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") [basically asking for the month
of Jan 1, 1900]

In this case, the formula is not influenced by the date encoding scheme
and will yield the desired result.

I hope this helps.

Rémy Gauthier.

Le vendredi 13 janvier 2017 à 15:17 -0500, Tanstaafl a écrit :
If it is its been there a long time, because I first encountered this
a
loooong 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
<joeconner2007@gmail.com> wrote:
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???

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




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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.