Thank you so much - problem solved!!
--
Susan


"Jarek Kujawa" wrote:

with
A1=13/09/2003
A2=09/04/2009

you might use

=DATEDIF(A1,A2,"y")

DATEDIF is not described in HELP, "y" is for years, "m" for months,
"d" for days

BTW with given dates the correct result would be 5, not 25



"Susan Sia" .(donotspam) skrev i ...



How can I calculate age accurately? If I put in the following two dates
and
use the "Callculate the number of years between two dates" function, I get
26
as the answer, whereas the actual age is 25.

13/09/2003
09/04/2009
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -