Hi,

With your retirement date in a1 try

=DATEDIF(TODAY(),A1,"y")&" Years "&DATEDIF(TODAY(),A1,"ym")&" Months"

Mike

"Using the date functions" wrote:

Hi, thanks to any one who can help.
I'm using Excell 2000 and would like to do the above in a exsisting wookbook.
Sad I know, but my other hobby is digital photography, and that is takeing
all my thoughts.

Thanks