Try the following undocumented formula:-

=DATEDIF(C1,D1,"Y")

where C1 is the Start date cell, D1 is the End date cell and Y is the
date diffrence in years


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=520668