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