Excel - Calculate age from DOB in years, months days

P

Polly

Might seem obvious but I can't find an answer in Excel Help. I am trying to
calculate age in years, months and days by subtracting cell containing date
of birth from cell containing today function. Using 2007.
Many thanks.
 
E

Eduardo

Hi,
I assume you have today() formula in D5 and entered the new date in E5

=DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
"&DATEDIF(D5,E5,"md")&" days"
 
P

Polly

Many thanks, it works.

Eduardo said:
Hi,
I assume you have today() formula in D5 and entered the new date in E5

=DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
"&DATEDIF(D5,E5,"md")&" days"
Click to expand...
 

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

How to use/create code in MS Word to calculate age? 0
Calculating Current Age from DOB 3
calculate average values for 100 records in the shortest way? 5
Excel formula calculating age 4
Calculating age of death 30
Completed years and monhts 7
How do I calculate a persn's age in years & months in Excel? 4
Error message needed if incorrect Date Of Birth (DOB) entered 5

Top