Months to years conversion help please

[jedibrown]

Good morning everyone,

I have been trying to figure out a formula to convert the amount of months in a certain cell to years.

I have come up with:

=INT(E29/12)&" years "&MOD(E29,12) & " months"

The problem is it comes up with 2 years 3.37063951499227 months

Does anyone know how I change it to come up with 2.4 months, round it to the highest number instead of loads of decimal places? I have tried change cell E29 do 0 decimal places but it doesn't work.

Many thanks

 

[VoG]

Try

=INT(E29/12)&" years "&TEXT(ROUNDUP(MOD(E29,12),1),"0.0") & " months"

 

[jedibrown]

Hi VoG,

Thank you for your help.

That returns 2 years 3.4 months so doesn't round up to 2.4 but - that's good enough for what I need. Thank you very much!