I think you'll find that DATEDIF is *not* part of the Analysis ToolPak, but
is a native Excel function.
--
David Biddulph

"Chris" wrote in message
...
Hi - just found that Datedif works - it is part of the ToolPak install.
Thank
you for your help!!!!

" wrote:

You could try something like this:
=TRUNC((TODAY()-B7)/365.25)&" year, "&MOD(((TODAY()-B7)/365.25),
1)*12&" months"

I don't know the Datedif function and I can't find a reference to it
in help in Excel 2003, but it would make for a prettier formula.
Is Datedif part of toolpack?

On Mar 12, 2:52 pm, Chris wrote:
Hi - need some help here...

Does anybody know how to display a number as years and months?
I would like to show 1.8 as 1 year, 9 months instead of a decimal.

The 1.8 I get by subrtracting my start date from today's date....
=today()-Cell with start date/365