Well, not knowing exactly how you want the results formatted, here's one
approach:
If the value is in cell A1 then, put this formula in any other cell:
=ROUNDDOWN(A1,0)&" years, "&ROUND(MOD(A1,1)*12,0)&" Months"
In your example, 4.66666 would display as "4 years, 8 months"
Does that help?
Regards,
Ron
"John" wrote:
Hello.
If I have a figure such as 4.6666667, that I would like expressed in
Years and Months, to the nearest month, what formula would I use to do
this? Is it possible in Excel?
Cheers
John
|