We help IT Professionals succeed at work.

# Convert Date of birth in Excel

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

## View Solution Only

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

Commented:
needed to clarify my question

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: