In A1
63

In B1
=IF(COLUMN(A1)<=INT($A1/12),12,IF(COLUMN(A1)=INT($A1/12)+1,MOD($A1,12),""))

and copy the formula to the right as required C1,D1 etc;

If this post helps click Yes
---------------
Jacob Skaria


"Hank" wrote:

Hello,

I need help to breakdown total months to months by year

for example total months is 39, I need a fomula to break down to 12, 12,
12, 3 in number.

Thanks for your help.

Hank