Marguerite

With early date in A1 and later date or =TODAY() Function in A2

=DATEDIF(A1,A2,"y") & "years," in A3

To get finer resolution enter in A3

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

Note: above is all one line.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 11:14:11 -0700, "Kathy"
wrote:

What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.

Yes, I know I can just subtract but is there a formula that can do it?

Marguerite