Use =DATEDIF(A1,A2,"y")

This is also available in VBA as DATEDIFF()

If this post helps click Yes
---------------
Jacob Skaria


"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