month function

[jordanpcpre]

Is there a way to use the month function so that if 12 is inputed, December
will be the output? Rather than the reverse. I tried

=Month(12)

but that doesn't return December. Could you help me please?! Thanks!

 

[Max]

Assuming the "month" numbers are input in C1 down,
you could use something like this in say, D1, copied down:
=IF(OR(C1="",C1>12),"",VLOOKUP(C1,{1,"January";2,"February";3,"March";4,"April";5,"May";6,"June";7,"July";8,"August";9,"September";10,"October";11,"November";12,"December"},2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik

 

[TomPl]

You could use the formula =month(1900,12,1) then do a custom format on the
cells with the formula of mmmm. That works for me.

Tom

 

[Rick Rothstein \(MVP - VB\)]

This should work...

=TEXT(28*A1,"mmmm")

where A1 contains your month number; of course, you could use the number, or
a calculation that results in the number, directly...

=TEXT(28*12,"mmmm")

Rick

 

[Rick Rothstein \(MVP - VB\)]

As it turns out, you can save the function call and just use this...

=28*A1

where A1 contains the month number, or you can use this..

=28*12

where you would use whatever the number is in place of the 12, then use your
'mmmm' custom format.

Rick

 

[TomPl]

That is very clever. Good job!

Tom

As it turns out, you can save the function call and just use this...

=28*A1

where A1 contains the month number, or you can use this..

=28*12

where you would use whatever the number is in place of the 12, then use your
'mmmm' custom format.

Rick

 

[Rick Rothstein \(MVP - VB\)]

Thanks. As it turns out, you can use either 28, 29 or 30 for the multiplier
constant.

Rick

 

[Rick Rothstein \(MVP - VB\)]

Just to point out, you can use either 28, 29 or 30 for the multiplier
constant... your choice.

Rick

 

[Maverick_TG]

Just to point out, you can use either 28, 29 or 30 for the multiplier
constant... your choice.

Rick

message



- Show quoted text -

Although answered, another way of going about it is to use the choose
function

=choose(A1, "Jan", "Feb", "Mar",etc...) Therefore, if a 12 is
entered, the formula will look to the 12th label within and result in
Dec