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