Birthdate Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Birthday Formula 3
SUM Q 2
converting text into years 4
Max Value - based on a time period 3
countifs Function not giving desired result with date criteria 2
Add 2 days before and after birthdate 4
Project a date and calculate a % in one formula 4
Complete Tax Years 1

Back
Top