kkelley6
asked on
Convert Date of birth in Excel
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER