Here is the formula I just found to calculate age:

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

You can reference this link: http://www.cpearson.com/excel/datedif.htm

"brenner" wrote:

using todays date what formula do i use to calculate a person age using their
date of birth