Excel formula to calculate age

T

Tim

I hope there is an easy formula in Excel that will calculate a person's
age given their date of birth. And update that age when next the
spreadsheet is opened.

thanks
Tim
 
J

J.E. McGimpsey

Tim said:
I hope there is an easy formula in Excel that will calculate a person's
age given their date of birth. And update that age when next the
spreadsheet is opened.
Click to expand...

One way:

A1: <dob>
B1: =DATEDIF(A1, TODAY(), "y")

DateDif is not documented in any XL version other than WinXL2000.
For an explanation of the function and its options, see

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