try the datedif() function
(not covered in help unless you have 2000)
=datedif(birthdate.today(),"y") for years
=datedif(birthdate.today(),"ym") for monthssince last bithday
=datedif(birthdate.today(),"md") for if you are also interested in days
You can see more info at

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

"cdu311" wrote:


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