Tulip

=DATEDIF(A1,B1,"y") & "years," & DATEDIF(A1,B1,"ym") & "months,"&
DATEDIF(A1,B1,"md") & "days,"

Birthdate in A1....................given date in B1

Watch for wordwrap.................above formula is one line.


Gord Dibben MS Excel MVP

On Sun, 8 Jul 2007 10:12:01 -0700, Tulip
wrote:

How can you calculate the age of a person on a given date (and knowing the
date of birth)? And how can you format cells to show age in years and months
- and calculate the difference between two eg the difference in years and
months between someone who is 10 years and 7 months and someone who is 11
years and 2 months?
And how can this be displayed in a chart?