Text formula: Months

[zdinath]

Hi,

Possible reasons why my Text formula to display month values as the actual text always outputs "Jan"?
e.g. =Text(1,"mmm") = Jan
=Text(2,"mmm") = Jan
=Text(3,"mmm") = Jan, etc

Any assistance will be appreciated.

Regards,
Z

 

[VoG]

Perhaps

=CHOOSE(A1,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

 

[zdinath]

That works...thanks.
But still means having to type all the months in the formula (or having it in a range somewhere), which is what i was trying to avoid.

Its strange cos i used the Text method previously and it worked fine but somehow not getting it to work now (its working for days of the week...just not months?!?!?!)

 

[VoG]

If you use

=Text(3,"mmm")

it is converting 3 January 1900 into a month, =Jan.

 

[Andrew Poulsom]

The number 1 is 01 Jan 1900 when formatted as a date, and the number 2 is 02 Jan 1900. That's why you are getting Jan for both formulas. You can use these formulas:

=TEXT("1/"&1,"mmm")
=TEXT("1/"&2,"mmm")

assuming your date setting is dd/mm/yyyy.

 

[Weaver]

try:

=TEXT(DATE(0,3,1),"mmm")

 

[zdinath]

You 100% correct!!!
Jeez...i would never have thought about that. Thanks

I's now using:
=TEXT(DATE(,A2,),"mmm")

where A2 is the number i need to display in the month format.
Thanks for the help

Regards,
Z

 

[T. Valko]

You 100% correct!!!
Jeez...i would never have thought about that. Thanks

I's now using:
=TEXT(DATE(,A2,),"mmm")

where A2 is the number i need to display in the month format.
Thanks for the help

Regards,
Z

If A2 is a number from 1 to 12...

=TEXT(A2*29,"mmm")

 

[Andrew Poulsom]

For me:

=DATE(,2,)

returns 31 January 1900 not February.