Quote:
Originally Posted by hannu
my second email is still searching for a simple answer to the problem of displaying the age of a person in years, months and days, when the DOB and todays date are known.
|
That is what the formula I posted solves, where the DOB is in A1 and today's date is in B1. Of course, if you don't want to have today's date in B1, you could use:
=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months & "&DATEDIF(A1,TODAY(),"MD")&" days"
Similarly, if you had only a number of days in B1, without knowing the DOB you could get an approximation with:
=DATEDIF(0,B1,"Y")&" years, "&DATEDIF(0,B1,"YM")&" months & "&DATEDIF(0,B1,"MD")&" days"