you need to change your formatting for the resula cell so it won't give you a
date:
change the formatting for 02/19/1900 cell by:

format--cell--number--change to number

"AB" wrote:

Nikki,

Thanks. I tried that but it gave me 02/19/1900.

Adam

"Nikki" wrote:

A1: 12/20/2005
A2: 12/20/1955
formual
=year(a1)-year(a2)

gives you 50.

"AB" wrote:

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