breakdown months

[Hank]

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

 

[Gary''s Student]

with 39 in A1, use:
=A1/12 in another cell - this will display 3.25 for the three years and a
little left over.

 

[Jacob Skaria]

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

 

[Hank]

You are awesome!! Thanks Jacob

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