We help IT Professionals succeed at work.

Convert Date of birth in Excel

kkelley6
kkelley6 asked
on
I need to convert some date of births to figure out if individuals are eligible to attend functions.  I have spreadsheets that that is set up like so....

Name    :     Date of Birth  : Current Age

user1         1/1/1952        49 years 10 months


so what I want is to put the date of birth in B2 and it print the age with year and month in C2 or a decimal date (49.10) for example
Comment
Watch Question

Commented:
Use:

=DATEDIF(B2,TODAY(),"y")

Obviously change the B" accordingly.

A fuller example:

   A    B               C
1  Name     Date of Birth     Current Age
2  John     23866     =DATEDIF(B2,TODAY(),"y")
3  Craig     25389     =DATEDIF(B3,TODAY(),"y")
4  Clare     16497     =DATEDIF(B4,TODAY(),"y")
5  Emma     27364     =DATEDIF(B5,TODAY(),"y")
6  Susan     30053     =DATEDIF(B6,TODAY(),"y")
7  Bill     31180     =DATEDIF(B7,TODAY(),"y")
8  Jane     28407     =DATEDIF(B8,TODAY(),"y")


:o)

Ant

Author

Commented:
needed to clarify my question

Author

Commented:
i rephased the question that i had initally posted but, I was able to figure it out with the solution that you had offered.  Having no function experience, I was able to modify your solution for my needs.  Thank you very much.

Commented:
Glad to help. :o)

Ant

P.S. Please note that anybody viewing this in the future, the question was edited after my original comment was posted and hence doesn't completely appear to answer the question.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.