Dates = years old

Guest · Jul 25, 2007

Cell J2 has DOB - 1/4/1993
Cell K2 has AGE

How can I get K2 to insert age? (years only)

Guest · Jul 25, 2007

try:

=DATEDIF(J2,TODAY(),"y")

Guest · Jul 25, 2007

Got it. Thank you Toppers!!

Toppers said:
try:

=DATEDIF(J2,TODAY(),"y")

Guest · Jul 25, 2007

To get the age as of 1-Jan-2007
In K2: =DATEDIF(J2,--"1-Jan-2007","y")