=INT(A1/12)&" years and "&MOD(A1,12)&" months."


wrote in message
...
hi

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

thanks for any help