|
|
|
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
Click here to sign up for more FREE tips
|
Check out these other pages that may be of interest to you: |
|