View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Displaying a decimal as years and months

You could use DATEDIF in your formula to derive the answer in years
and months directly - Chip Peasron explains how he

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

Hope this helps.

Pete

On Mar 12, 6: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