Birthdate Formula

M

mortola

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.
 
A

Arvi Laanemets

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
 
Top