MONTH Function in EXCEL

[Tom]

I know the MONTH function in EXCEL will return a number from a list of Month
Names, e.g. January = 1, February = 2, etc. But I have a list of numbers
that I would like to return the month name. Can it be done?

 

[Shane Devenshire]

Hi,

create a lookup table like
1 January
2 February
....

suppose you do this is in G1:H12

use the formula
=VLOOKUP(A1,G1:H12,2,FALSE)

where A1 contains the number.

 

[JE McGimpsey]

I know the MONTH function in EXCEL will return a number from a list of Month
Names, e.g. January = 1, February = 2, etc. But I have a list of numbers
that I would like to return the month name. Can it be done?

One way:

=TEXT(DATE(2000,A1,1),"mmmm")