MONTH(a1)

F

frsm

I'VE ACHANGEABLE NUMBER IIN a1 AND I PUT IN b1 "=MONTH(A1)
IN ORDER TO GIVE ME THE MONTH'S NAME WHEN I CHANGE THE NUMBER IN
A1 BUT IT DDINT WORK
WHY?
PLZ HELP
THANXXXXXXXXXXXXXXXX FOR AL
 
L

L. Howard Kittle

I believe you have to have a date in A1, not just a number.

HTH
Regards,
Howard
 
P

Pete_UK

Even if you have a date in A1, the MONTH( ) function only returns an
integer which represents the month, i.e. 1 for January, 2 for February
etc.

Hope this helps.

Pete
 
B

Bob Phillips

Try

=CHOOSE(A1,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov"
,"Dec")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
A

Anand Iyer

The best way to get an answer to this is using the =vlookup formula

1) List all months starting from January to December row by row in
column D1
2) Add serial numbers against the months in column C1 i.e. 1 January 2
February etc
3) Assuming that you will enter the month number in cell A1, enter this
formula in cell B2 without the quotes "=vlookup(a1,c1:d12,2,0)". This
will do the trick.

Regards

Anand Iyer
 
Top