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 he
http://www.vbaexpress.com/kb/getarticle.php?kb_id=323

HTH, and regards,
Zack Barresse


"Kathy" wrote in message
...
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