Excel Question
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
|