Is there a formula to keep track of age?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Thanks for the quick response. I'll give that site a look-over to
familiarize myself with the function.
 
Back
Top