Apologies below formulae will calculate number of months and has to be
divided by 12 to get to age..

Regards
Ajay

"Ajax" wrote:

Hi Sue

If Dates were A1(13/09/1983) and A2(09/04/2009) please use below formulae to
calculate age correctly.


=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)

Regards
Ajay


"Susan Sia" wrote:

I apologise to all. The first date should have been 13/09/1983. Can you
still help?
--
Susan


"Susan Sia" wrote:

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