formula help

[John]

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

 

[Guest]

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