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!
|