View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kimmie B
 
Posts: n/a
Default Convert years to years and days

I want to create a formula that converts years into years and days.

For example, turn 7.65 years to text that reads: 7 years, 237 days.
I want the formula to round the days to the nearest whole number.

I am VERY new at Excel, so please provide explicit instructions.

Thanks in advance for your help!