Hi

Chip Pearson's web page
http://www.cpearson.com/excel/datedif.htm#Age

has the following info:
Calculating A Person's Age

A frequent use of the DATEDIF is to compute someone's age based on the
current date and their birthday. The formula below will return someone's
exact age based on their birthday in cell A1.


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

This will return a string like

33 years, 9 months, 18 days



instead of NOW() (which uses the current date) you can put another cell
reference in containing the date you want their age known at.

Cheers
JulieD

"CPD174" wrote in message
...
I want to figure the age of a person based on two entered dates, their
birthday and another date of occurrance. I want this to reflect whether
or
not their birthday has yet occurred in this calendar year.