Converting dates to a number

[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

 

[zackb]

A very rough way of doing so, if you don't need to count leap years ...

=Int((Today()-A1)/365)&" years old"

Where A1 is the cell which houses your date. Note this MUST be an Excel
recognized date. To check if it's an Excel recognized date, look here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=323

HTH, and regards,
Zack Barresse

 

[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

 

[Andy Wiggins]

Here's a link to DATEDIF that might help you.

http://www.bygsoftware.com/Excel/functions/datedif.htm

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy