Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
Assuming the "month" numbers are input in C1 down,
you could use something like this in say, D1, copied down: =IF(OR(C1="",C112),"",VLOOKUP(C1,{1,"January";2," February";3,"March";4,"April";5,"May";6,"June";7," July";8,"August";9,"September";10,"October";11,"No vember";12,"December"},2,0)) -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "jordanpcpre" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
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 "jordanpcpre" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
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 "jordanpcpre" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
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" wrote in message ... 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 "jordanpcpre" wrote: 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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
That is very clever. Good job!
Tom "Rick Rothstein (MVP - VB)" wrote: 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" wrote in message ... 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 "jordanpcpre" wrote: 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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
Thanks. As it turns out, you can use either 28, 29 or 30 for the multiplier
constant. Rick "TomPl" wrote in message ... That is very clever. Good job! Tom "Rick Rothstein (MVP - VB)" wrote: 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" wrote in message ... 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 "jordanpcpre" wrote: 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! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
Just to point out, you can use either 28, 29 or 30 for the multiplier
constant... your choice. Rick "Rick Rothstein (MVP - VB)" wrote in message ... 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 "jordanpcpre" wrote in message ... 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! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
month function
On Jul 7, 9:17*am, "Rick Rothstein \(MVP - VB\)"
wrote: Just to point out, you can use either 28, 29 or 30 for the multiplier constant... your choice. Rick "Rick Rothstein (MVP - VB)" wrote in . .. 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 "jordanpcpre" wrote in message ... 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!- Hide quoted text - - 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
=Month function in Excel gives incorrect month | New Users to Excel |