Converting dates to a number

G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top