Assume birthdate in A6 and today date in A7

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"

Watch for word wrap. Formula is one line.


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 13:40:05 -0700, paralegal
wrote:

is there an easy way to do this through a formula? I tried using the year
function and subtracting from current date but is doesn't caluculate
correctly if the birthday hasn't yet occured in current year. Thank you.