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

[Mein]

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

 

[T. Valko]

Try this:

A1 = date of birth

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

Biff

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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