Use the largely undocumanted DATEDIF() function. Chip has a good
explanation he

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dan Cotts" <Dan wrote in message
...
In the Help menu, I can see how to do it in years, and I can see how to do
it
in months, but how do I do YY, MM? - I am trying to calculate retirment
ages.