Try the Datedif function.

It's undocumented except in XL2k.

BUT, you can find it explained at Chip Pearson's web site at:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"smith.james0"
wrote in message
news:smith.james0.1ptaab_1117400703.8379@excelforu m-nospam.com...

I need to work out how many years and months someone been alive. Can
anyone help?


--
smith.james0
------------------------------------------------------------------------
smith.james0's Profile:
http://www.excelforum.com/member.php...o&userid=16230
View this thread: http://www.excelforum.com/showthread...hreadid=374933