Displaying a decimal as years and months
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
|