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

R

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"
 

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

Expanding Date Formula 0
age 3
Date / month / year 1
Excel - Calculate age from DOB in years, months days 7
Month days over a time period 5
find out specific month and year 1
Percentage of month passed formula 1
calculating payment terms "End of Month +30". 1

Top