date calcuations

Posted by Doug on September 27, 2001 3:21 PM

I want to be able to enter someones birthday and get the age in years, months and days. Can't find the answer and 3 of us have been working on the problem.

thanks

Posted by Paul on September 27, 2001 3:52 PM

From:http://www.cpearson.com/

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