Age using date formula

[Richard St John Ambulance UK]

. Reply (E-mail) Forward (E-mail)

Subject: Age using date formula.
From: "Richard - St John Ambulance UK"
<[email protected]> Sent: 7/21/2004
10:05:25 AM



I made a mistake on my other posting.... This is the
proper one!
If I use the following formula to calculate members ages
in years it seems to round up after about 6 months and 20
days. e.g. someone who is 16years 6 months 21 days old
is
displayed as 17. Can one of you clever people help?

=YEAR(N1)-YEAR(F52) (Year (N1) is taken from the current
date, TODAY().)

Thanks in advance!

Richard

 

[Dave R.]

Richard- you might also familiarize yourself with searching Google groups
(link in my reply to your first post). It is the recommended first stop for
common issues like calculating age.

 

[Richard]

Many, many thanks Dave! it is now solved.

-----Original Message-----
Richard- you might also familiarize yourself with searching Google groups
(link in my reply to your first post). It is the recommended first stop for
common issues like calculating age.



"Richard St John Ambulance UK"