CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS

[jr]

so it shows a result of "15 years 4 months and 6 days" for example.

 

[Roger Govier]

Hi

With earliest date in A1 and latest date in A2
=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months
"&DATEDIF(A1,B1,"md")&" days"