how do I work out age in years, months, days in excel

T

Tru Colours

I'd like to be able to work out ages in years, months and days - in excel -
but I just can't figure it out.
I've managed to do years and points (tenths) of a year but would like to be
much more accurate.
Can anyone help please?
Thanks in advance.
 
J

Jacob Skaria

With DOB in cell A1

=DATEDIF(A1,TODAY(),"y")&" years "&
DATEDIF(A1,TODAY(),"ym")&" months "&
DATEDIF(A1,TODAY(),"md")&" days"

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

years-months-days-hours 5
Age Calculation 4
problem of calculating years months and days 1
convert # of years, months and days 4
changed DOB to age, but if no DOB need cell to be empty. 4
subtract years and months (as in ages) from another age 3
year on year tracking 4
Problem With Converting Days Months And Years 1

Top