599CD.com Eight New Handbooks Posted   Collapse Menus
 
 
NEW Courses - Excel 2007 Level 4 & 5, Access Security dismiss
 
   
 

What's New?  |  Courses  |  Theater  |  Demo  |  Tips  |  Blog  |  Forums  |  Search  |  Help  |  Order

 
What do you want to learn today? 
 
New Tips Added Weekly. Get Notified of New Tips & Tricks.
 
     
 
Tips & Tricks
   

  Access   Excel   Word   Windows   FrontPage   Hardware   Misc

 
 
Get Month Names from Dates
Using the MONTH Function, a Named Range, and the VLOOKUP Function
 
Q: I have a column of dates in my sheet. I would like to be able to take a date like 5/1/2000 and get the month name (i.e. "May") out of that date. How can I do it?
A: Excel doesn't have a built-in MonthName function, but with a couple of tricks you can do this easily enough.
 

First, use the Month() function to get the numeric version of the month. This will convert 1/1/90 into "January."

Next, create a Lookup Table that has your list of months in it (January thru December) in whatever format you want.

Now, use the VLOOKUP function to find your month in that list.

We have a FREE video tutorial that shows you how to do this step-by-step.
 
 Click here to view the FREE video
 

We have another FREE video tutorial that explains the VLOOKUP Function in more detail.
 

 

Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now.
 

You may want to read these articles from the 599CD Blog:

 

 

Need Help
 
Do you have questions about Word, Excel, Access, Web Design, or computers in general? Just ask us anything you'd like. Click here for assistance.
 

Get Free Tips & Tricks
 

Join our mailing list today and get information on our Free Tips & Tricks Newsletter including free video tutorials, eBooks, live seminars, and more.

Email:
Name:
Type in the word to the left:
 
Your email will be kept 100% safe and will never be given to 3rd parties.
 


CLICK HERE for a FREE lesson



Order your first 599CD course now.
Your Satisfaction is Guaranteed!


Subscribe to our RSS FeedWhat's This?

599CD on Facebook  599CD on Twitter  Subscribe to RSS Feed  Add to Live Bookmarks  Add to My AOL  Add to MyYahoo  Add to Google Reader or Homepage    hide help

599CD Home   |   Learn More   |   What's New?   |   Contact Us   |   Free Demo   |   FAQs   |   Order Now   |   Affiliate Program   |   TechHelp   |   MYOLP   |   Jobs   |   Downloads   |   Handbooks  (Text)   |    Mailing List   |   Lost Passwords   |   Referral Program   |   Online Poll   |   Corporate, Educational, Government, Non-Profit Sales   |   Message Forums   |   Testimonials   |   Privacy Policy   |   Free Gift CDs   |   Tips & Tricks