If you already have a number that includes both years and months (e.g. 34.5, which represents 34 years and 6 months), you can use the formula =INT(A1) & " years, " & ROUND(MOD(A1,1)*12,0) & " months" to display it in the format of years and months.