convert a number to month


3

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

Advertisements

C

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
 
3

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

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
 
3

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
 
C

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
 
Ad

Advertisements

3

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top