Using numbers for months (1-12)

[alphaexcel]

Is there any way to bring across a month value based on the numbers 1-12?

Can do weekdays etc, but not month i.e. if A1 = 5, then show the month value, which would be May?

Cheers

 

[Jonmo1]

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

Hope that helps..

 

[schielrn]

You could do something like this:

=CHOOSE(A1,"January","February","March","April","May")

Or you could use the date function combined with the text function to return month:

=TEXT(A1&"/01/2008","mmm")

Hope that helps.

 

[JimmyG]

Hope I've understood correctly....

assuming a month number in cell A1, enter in B1:

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

Can also be adapted for QTRs
=CHOOSE(A1,"Q1","Q1","Q1","Q2".... etc



Regards, JimmyG

 

[alphaexcel]

Thanks for you input. Seems i was a little off with one of the formulas. Ive managed to work it through now (based on suggestions). The cell A1 contains a string that represents a date in the (unrecogniseable) format 31/05/2008:11:00:05 and so the following formula does the trick :

=TEXT(DATEVALUE(MID(A1,1,10)),"mmmm")

Returns the month as a string (that I can now use in an indirect function to reference to other tabs)

Thanks again