formula help

J

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
 
R

Ron Coderre

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
 
Top