Excel - Calculate age from DOB in years, months days

  • Thread starter Thread starter Polly
  • Start date Start date
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.
 
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"
 
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...
 
Back
Top