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 do I calculate ages of employees in Excel? 1
age formula showing months 2
calculate no. of years between a date and today's date 10
Calculate age 5
Calculting Age 1
Date calculation (If then type) 2
Calculating Years, Months & Days 3
calculate date differences in years and months 1

Top