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

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


"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

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

You are awesome!! Thanks Jacob

"Jacob Skaria" wrote:

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