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