I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A. Is
there a formula that can calculate into number of years to the present date.
For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach
this, thanks inadvance. Using office 2000.

Do you know Joe?

--
Don Guillett
SalesAid Software

"mortola" wrote in message
...
I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A.
Is
there a formula that can calculate into number of years to the present
date.
For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach
this, thanks inadvance. Using office 2000.

hi

P.e.
B2=DATEDIF(A2,TODAY(),"Y")

or when you want month and days too, then
B2=TRIM(IF(DATEDIF(A2,TODAY(),"Y")=0,"",DATEDIF(A2 ,TODAY(),"Y") & " year" &
IF(DATEDIF(A2,TODAY(),"Y")2,"s "," ")) &
IF(DATEDIF(A2,TODAY(),"YM")=0,"",DATEDIF(A2,TODAY( ),"YM") & " month" &
IF(DATEDIF(A2,TODAY(),"YM")2,"s "," ")) &
IF(DATEDIF(A2,TODAY(),"MD")=0,"",DATEDIF(A2,TODAY( ),"MD") & " day" &
IF(DATEDIF(A2,TODAY(),"MD")2,"s","")))


Arvi Laanemets


"mortola" wrote in message
...
I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A.
Is
there a formula that can calculate into number of years to the present
date.
For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to aproach
this, thanks inadvance. Using office 2000.

Do you mean Joe Mortola?

"Don Guillett" wrote in message
...
Do you know Joe?

--
Don Guillett
SalesAid Software

"mortola" wrote in message
...
I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A.
Is
there a formula that can calculate into number of years to the present
date.
For example, Col A= 04/7/04, Col B =1 year. I'm not sure how to
aproach
this, thanks inadvance. Using office 2000.