Is there a formula to keep track of age?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lsyep - 24 Oct 2006 23:42 GMT

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

Reply to this Message

Paul B - 24 Oct 2006 23:48 GMT

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

Signature

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

> 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
[quoted text clipped - 3 lines]
> Name Birth Date Current age
> John Doe 01/01/2001 5

Reply to this Message

lsyep - 25 Oct 2006 00:05 GMT

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

> lsyep, =DATEDIF(B1,TODAY(),"y") with date in B1
> you may also what to have a look here for more information on datedif
[quoted text clipped - 9 lines]
> > Name Birth Date Current age
> > John Doe 01/01/2001 5

Reply to this Message

Rate this thread: