Formula to work out someones age

  • Thread starter Thread starter mikey
  • Start date Start date
M

mikey

I am putting together a database using excel and wish to enter a persons
date of birth as a column and then have excel work out the persons age in
the next column. Can anyone tell me the formula I should be using to do
this?

I'm using excel 97 on windows 95

Regards

Mike

(e-mail address removed)
 
one way:

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

where A1 contains the birthdate
 
This will return years, months and days:
=DATEDIF(D9,NOW(),"y")&" years, "&DATEDIF(D9,NOW(),"ym")&" months,
"&DATEDIF(D9,NOW(),"md")&" days"
 
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

formula to work out someones age 1
formula to work out a persons age 1
Calculating age from date of birth and ignoring if blank 5
Calculating age from two date fields-Excel 2003 3
Calculate age 3
date of birth age formula 8
calculating age 8
Age 5

Back
Top