It depends if 1995 is taken to be the first of January

A1-(date(b1,1,1,) and format as date yy mm dd

or

(A1-(date(b1,1,1,) )/365.25
or

year(a1)-b1


Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561408