Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

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.    We have another FREE video tutorial that explains the VLOOKUP Function in more detail.

By Richard Rost

 Check out these other pages that may be of interest to you:
 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab 8/10/2022 Transpose 7/26/2022 Lottery Numbers 2 7/22/2022 Lottery Numbers