ExcelBanter - Dates = years old

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dates = years old (https://www.excelbanter.com/excel-discussion-misc-queries/151653-dates-%3D-years-old.html)

Brurobiney

Dates = years old

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

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

Toppers

Dates = years old

try:

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

"Brurobiney" wrote:

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

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

Brurobiney

Dates = years old

Got it. Thank you Toppers!!

"Toppers" wrote:

try:

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

"Brurobiney" wrote:

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

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

Max

Dates = years old

To get the age as of 1-Jan-2007
In K2: =DATEDIF(J2,--"1-Jan-2007","y")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brurobiney" wrote:
Cell J2 has DOB - 1/4/1993
Cell K2 has AGE

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

All times are GMT +1. The time now is 03:38 AM.