convert a number to month

[3Suk]

dear all,
how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?
I know use vlookup in another table will work, but I prefer a direct formula.

Thanks in advance.
Patrick.

 

[Claus Busch]

hi Patrick,

Am Tue, 15 Jan 2013 00:14:40 -0800 (PST) schrieb 3Suk:

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?
I know use vlookup in another table will work, but I prefer a direct formula.

try:
=TEXT(DATE(1,A1,1),"MMMM")


Regards
Claus Busch

 

[3Suk]

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.



Thanks in advance.

Patrick.

Claus,
It works. how about vice versa, a month to a number?

Thanks,
PL.

 

[Claus Busch]

Hi,

Am Tue, 15 Jan 2013 23:11:17 -0800 (PST) schrieb 3Suk:

It works. how about vice versa, a month to a number?

the month name in A1 then:
=MATCH(A1,TEXT(ROW(1:12)*28,"MMMM"),0
and enter the formula with CTRL+Shift+Enter (Array formula)


Regards
Claus Busch

 

[3Suk]

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.



Thanks in advance.

Patrick.

it returns #VALUE!.
moreover, how to enter with "ALT+shift+enter" and why has to do it?

Thanks
Patrick

 

[Claus Busch]

Hi Patrick,

Am Tue, 15 Jan 2013 23:55:44 -0800 (PST) schrieb 3Suk:

it returns #VALUE!.
moreover, how to enter with "ALT+shift+enter" and why has to do it?

the formula is an array formula. You have to enter it with
CTRL+Shift+Enter and then the formula gets the curled parenthis.
if you don't finish with CTRL+Shift+Enter you get #Value


Regards
Claus Busch

 

[3Suk]

dear all,

how can I convert a number to month, e.g. in A1 = 2, then the formula in B1 will convert to show "February"?

I know use vlookup in another table will work, but I prefer a direct formula.



Thanks in advance.

Patrick.

get it.
Thanks.
Patrick