Calculating ages

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

Guest

How can I calculate the age a pupil is at the current date. For example, we have one field into which is typed date of birth. We'd like a second field show the age the child has reached as of today, in years and months. Your help would be very much appreciated. Thanks.
 
jay Jay,

Take a look here for some help on this:

http://www.cpearson.com/excel/datedif.htm#Age

John

Jay Jay said:
How can I calculate the age a pupil is at the current date. For example,
Click to expand...
we have one field into which is typed date of birth. We'd like a second
field show the age the child has reached as of today, in years and months.
Your help would be very much appreciated. Thanks.
 
Jay, have a look here

http://www.cpearson.com/excel/datedif.htm#Age

--
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 2000 & 97
** remove news from my email address to reply by email **
Jay Jay said:
How can I calculate the age a pupil is at the current date. For example,
Click to expand...
we have one field into which is typed date of birth. We'd like a second
field show the age the child has reached as of today, in years and months.
Your help would be very much appreciated. Thanks.
 
Hi Jay Jay!

=Datedif(A1,Today(),"y")&" years "&Datedif(A1,Today(),"ym")&" months
Returns age in completed years and months.

You may get some difficulties with interpretation but these are
probably acceptable. For example DoB 31-Jan-2000 does not click over 1
year 1 month until 1-Mar whereas you might interpret it as needing to
click over on last day of February. It's not wrong. Just an
interpretation issue.

For greater ease, I'd use years and weeks

=DATEDIF(A1,TODAY(),"y") & " years " &
INT((TODAY()-DATE(YEAR(A1)+DATEDIF(A1,TODAY(),"y"),MONTH(A1),DAY(A1)))
/7) & " weeks "

For details of the drunken cousin of the Excel functions (DATEDIF)
see:

Chip Pearson:
http://www.cpearson.com/excel/datedif.htm

Otherwise this Excel function is undocumented apart from sobering up
enough to warrant a mention in Help in Excel 2000.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Jay Jay!

Always willing! A Google Search on Age Excel will throw up a lot more
formulas for different ways of expressing it.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top