Use the DATEDIF function. E.g.,

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

See www.cpearson.com/excel/datedif.htm for more details about
DATEDIF.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Katiemcgi" wrote in
message
...
I am trying to create an Age column based on the DOB (Date of
Birth). What
is the formula for the Age Column??