Thanks for that - it works lovley but i would also like to
include months, erm - sorry to be a pain in the neck. if i type in (for
example) 12/08/1980 it comes back with 39 years but i need to show
months as well because it would actually be 39 years 11 months based on
65 year finish (41 years 11 months based on 67 year finish).

Much appreciated - you rock Ian!!!

Thanks

Lee




--
cdu311
------------------------------------------------------------------------
cdu311's Profile: http://www.excelforum.com/member.php...o&userid=27051
View this thread: http://www.excelforum.com/showthread...hreadid=468258