How can I convert a number, e.g. 1.5, into text which would read “1 year(s) and 6 month(s)”?
I can do it in Excel with =INT([output]) & " year(s), " & INT(([output]-INT([output]))*12) & " months"
As far as I can see there is no formula which allows the combination of maths and text. Any help would be fantastic, thank you.