Originally Posted by dazwm

In A2 for example put a persons DOB i.e 13/08/1969 then in B2 enter

=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days"

Copy down as needed.


The result will show the difference from the current date to include the number of years, months and days. The best news is that you don't have to update the formula if you open the file at a later date; the age will automatically recalculate based on the current date.