On Wed, 12 Mar 2008 12:22:35 -0700 (PDT), 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?

No, it is a native function in Excel, and has been present at least as far back
as 1995, maybe further (I don't have my documentation handy).

It is only in Excel HELP for 2000, but the function itself is present in most
other versions.

See http://www.cpearson.com/excel/datedif.aspx for documentation.
--ron