Spread whole number across specific months in a year

[rkobeyer]

Hi
Is it possible to spread whole numbers (not decimals) across a year?

For example if I have a total of 33 and I want to spread it from January to August the formula should give the below result.



J F M A M J J A S O N D
4 4 4 4 4 4 4 5

If 33 is spread evenly from January to December it would look like this:

J F M A M J J A S O N D
2 2 2 3 3 3 3 3 3 3 3 3

With larger numbers skewed toward the end of the year.

I have attached a file with the layout in excel and the expected totals the formula should give for each month.

I have been working on this all day but haven't gotten anywhere! You can see in Sheet 2 my previous attempts if it helps.

Any help I get I will be eternally grateful for!

MonthSpread.xlsm

Cheers,
Russell