View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Displaying a decimal as years and months

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