Solved: Break up total months into years and month

[tlchan]

Hi,

I would like to break up total number of months into No of years and month from cell F4 using function. Is anyone assist ?

Thank you

[p45cal]

=INT(F4/12)
and
=MOD(F4/12,1)*12
amongst many others

[tlchan]

Thanks P45cal for your solution.