what's the best way to calculate a person's years of age in excel
 

what's the best way to calculate a person's years of age in excel

what's the best way to calculate a person's years of age in excel
 

Try this:

A1 = date of birth

=DATEDIF(A1,TODAY(),"y")

Biff

"Mein" wrote in message
...
what's the best way to calculate a person's years of age in excel

what's the best way to calculate a person's years of age in excel
 

http://www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mein" wrote in message ...
| what's the best way to calculate a person's years of age in excel