We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Finding the month from a date field - Excel 2007

morinia
morinia asked
on
Medium Priority
173 Views
Last Modified: 2012-05-11
I have a worksheet that has date of birth in column D.  I would lke to calculate the month and put it in column E.

I tried  = month(D2) but this is not giving me the correct results.  Can someone tell me how to do this?

Column  D = 1/12/1936
Comment
Watch Question

Messaging and Directory Services
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
have you tried  the formula TEXT(D1,"Mmm")

this assume that the dob is in cell D1

It should give you December, assuming you are on UK regional settings, or January assuming you are in US regional settings.
moriniaAdvanced Analytics Analyst

Author

Commented:
The formula worked.  The problem was the field was defined as date instead of numeric.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
If you want month name, then you can use:
=TEXT(D2,"mmmm")
sorry, the above will give you Dec/Jan

TEXT(D1,"Mmmm") will give you December/January
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.