How to convert month number to month name
I am trying to add a dynamic date rang to the heading of a table. I can find the earliest and latest dates, and want to concatenate them in the heading...
January 1 2012 to January 31 2012
The day and year (and the other bits) are easy, but is there an easy way to convert 1 to January, without going through a vlookup
Last edited by FDibbins; 02-16-2012 at 09:18 PM. Reason: Figured it out
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: Excel 2007 : How to convert month number to month name
I have the same question that you had. You solved your issue but did not tell us how. Can you share?
HTScott, Godd afternoon.
Try to use:
Suppose the month number is at B4 cell.
=TEXT(MONTH(B4),"mmmm")
Please, tell us if it worked for you.
Have a nice day.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
The only way that I have been able to do it without a VLOOKUP is to use LOOKUP. The date is in B2:
Formula:
Please Login or Register to view this content.
Another way, that I just found with a date in B2.
Formula:Please Login or Register to view this content.
If you have a number in B2:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 05-14-2013 at 03:01 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
wow I posted that over a year ago, sorry for not posting whatever solution I had, way back when, but it seems the others have offered you some suggestions
For future reference, please start a new thread instead of "tagging" your question onto some1 elses thread (I know, this particular instance is in the grey areas seeing as you were asking what my solution was)
Mazzaropi, your solution did not work. 1 thru 12 all come up with "January". This is because the =MONTH function only works with a valid Excel Date/Time Code Serial Number. For example, the number 41586 is the serial number for 11/8/2013.
Newdoverman, your =LOOKUP and =TEXT solutions did not work, however, your =CHOOSE solution did. It is rather long to get a simple answer.
Since the =TEXT function allows you to format, I workded and came up with:
=TEXT(DATE(2013,B2,1),"mmmm")
I just used 2013 for the year and set the day to 1. Since they are not in the formatting I wanted, any year and day would work.
Thanks again for your help.
HTScott, what problem are you having as it appears to not be the question that I was responding to?
If done according to the conditions that I outlined for B2 the formulae do work so, I don't know what you are doing.
Last edited by newdoverman; 05-16-2013 at 09:34 AM.
If B2 contains month number try this formula
=TEXT(B2*29,"mmmm")
Audere est facere
It may be the difference between Excel 2007 and 2010. Thanks
daddylonglegs, your solution is the best. So simple and works great. Thanks
Re: How to convert month number to month name
Try to use this formula:Originally Posted by FDibbins
=TEXT(EOMONTH(B2,B2-1),"MMMM")
PS: Assuming 1,2,...,12 are in range B2:B13
Do not forget to confirm if it works for you.
Lmack, thanks for the suggestion
You may not have noticed that I added an edit that I had "figured it out"
I don't believe you can put a formula in a table heading?!?
I would put the date in the row above.
lolll, actually I was also stuck to it this morning and was looking for help at this forum. I saw your thread and the =TEXT(B2,"mmmm") solution which di not work but helped me to figure out including the EOMONTH function.
Xx7 - again, this thread is over 2 years old - and yes, you can put formulas in headings a normal "table", but not in a "created" Table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks