Converting number to month

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

I am not sure what goes wrong in the following formula, can anyone hel
me out?

=text(month(7),"mmmm")

The result will always show January, I wonder why?

I need to display July, August, September, etc....when the numbe
changes.

Please help
 
Hi Gilbert!

The MONTH function requires a Date Serial Number as its argument. 7 is
the Date Serial Number for 7-Jan-1900.

If you have a month number in A1, you can use:

=A1*29
Format as mmmm

The result of the calculation is a number and the serial numbers for
A1 1-12 are in consecutive months in 1900.

If the number is user input, it will be better to data validate for
whole numbers between 1 and 12.

You could keep an underlying date for the current year using:

=DATE(YEAR(TODAY()),A1,1)
Format mmmm
 
Hi

=CHOOSE(7,"January","February","March","April","May","June","July","August",
"September","October","November","December")
 
Back
Top