Formula to figure a persons age

[warshauer]

Hello all,

To better manage our employees on their life insurance plans we need to create a column in excel to calulate todays date and their date of birth and show the age.

Any help would be awesome.

Have a super day

 

[mintjulep]

something like:

=year(today())-year(DOB)

 

[xlhelp]

Rather than re-inventing the wheel, here is where you will find all the info you need.

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

Member- AAAA Association Against Acronym Abusers

 

[warshauer]

Thank you for the quick replies.

The cpearson.com is a great help.
I even found some things there that
will help in other areas.

Have a great holiday.