Use the DATEDIF function.

=DATEDIF(start_date,end_date,"Y")

For more info about DATEDIF, see
www.cpearson.com/excel/datedif.htm .


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


"AB" wrote in message
...
Hello All,

How can I subtract dates to get whole numbers in Excel? I am
trying to link
DOB's with a chart that rates based on age.

example: 12/20/2005 - 12/20/1955 = 50 years old.

Any and all assistance is greatly appreciated.

Thanks.

Adam