my answer stays unchanged
use it or use Per's solution


On 16 Kwi, 13:15, Susan Sia .(donotspam) wrote:
I do apologise to you and all who responded. Â*The first date should have been
13/09/1983. Â*This changes things slightly. Â*Can you still help?
--
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 -- Ukryj cytowany tekst -

- Pokaż cytowany tekst -