Thread: [Solved] Spread whole number across specific months in a year
View Single Post
 
Old 10-15-2014, 09:15 PM
rkobeyer rkobeyer is offline Windows 8 Office 2013
Novice
  
Join Date: Oct 2014
Posts: 2
rkobeyer is on a distinguished road
Smile Spread whole number across specific months in a year
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
Reply With Quote