One way:

=INT(A1/12) & IF(INT(A1/12)<1," years "," year ") & MOD(A1,12) &
IF(MOD(A1,12)<1," months"," month")





In article ,
wrote:

hi

How do i display 17 as 1 year 5 months, 26 months as 2 years 2months
etc etc

thanks for any help