In article , Lars Klintholm
writes
Try this one:

=IF(ISNUMBER(B1),IF(MOD(B1,12)=1,"year "&1+INT(B1/12),""),"")

--
Kind regards
Lars Klintholm


Hi Lars

Yes , that's perfect. Exactly the solution.

Thanks Lars. Impressive...!



Best Wishes