Hi,

Tr this

=DATEDIF(A1,A2,"y")

Datedif isn't documented in Excel so look here for help

http://www.cpearson.com/excel/datedif.aspx

Mike
"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