Is there a formula to keep track of age?

G

Guest

I'm trying to figure out if there's a way to keep track of age over time. Is
there a formula I can use to track age using birth dates against the current
date with years as the final entry?
IE

Name Birth Date Current age
John Doe 01/01/2001 5
 
P

Paul B

lsyep, =DATEDIF(B1,TODAY(),"y") with date in B1
you may also what to have a look here for more information on datedif
http://www.cpearson.com/excel/datedif.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
G

Guest

Thanks for the quick response. I'll give that site a look-over to
familiarize myself with the function.
 

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

How do I post a result of a query to a text box? 0
Missing Calculated Age Values 5
Calculating age from date of birth and ignoring if blank 5
Constant date in one cell 1
Age formula and length of time 1
Formula to calculate an age from a date of birth 5
date of birth age formula 8
Formula to Return age 2

Top