convert number to month literal in excel

P

peterell

I am trying to convert numbers in an excel spreadsheet to their corresponding
month name (eg. 6 to June). Is there a simple quick way to do this ?
 
A

Arvi Laanemets

Hi

=CHOOSE(A1,"January","February","March","April","May","June","July","August"
,"September","October","November","December")
or
TEXT(DATE(2000,A1,1),"mmmm")
 
D

Don Guillett

try this where c13 has the month number, ie:6
=TEXT(DATE(YEAR(TODAY()),C13,1),"mmmm")
or
=TEXT(DATE(YEAR(TODAY()),6,1),"mmmm")
 
Top