One way:

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

Use conditional to make the font red if A1 is negative:

CF1: Formula is =A1<0
Format: Font-Red


In article ,
wrote:

thanks but how can i cope with neg numbers

-3 will not shows as 3 months (Pef in red font)