[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

Finding the month from a date field - Excel 2007

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
0
morinia
Asked:
morinia
1 Solution
 
Raheman M. AbdulCommented:
Hope the following link helps you to find the month
http://www.youtube.com/watch?v=GjWPXW0at64
Used Month(A1) formula and used lookup table
0
 
RunriggerCommented:
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.
0
 
moriniaAdvanced Analytics AnalystAuthor Commented:
The formula worked.  The problem was the field was defined as date instead of numeric.
0
 
Rory ArchibaldCommented:
If you want month name, then you can use:
=TEXT(D2,"mmmm")
0
 
RunriggerCommented:
sorry, the above will give you Dec/Jan

TEXT(D1,"Mmmm") will give you December/January
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now