View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] reitanospa1@yahoo.com is offline
external usenet poster
 
Posts: 38
Default 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