Monthly Grid Populated using Start Month, End Month, and 3 other potential factors

[Scott Emmanuel]

Good Morning,

Goal is to populate a monthly grid based on an increase %, start month, end month, and then the months remaining for different factors.

The start month, end month, and annual factors can all vary.

I have completed the formulas for Months remaining, and # of months remaining for each factor, what I cannot complete is the formula for the end result.

The final piece is then multiplied by a seasonal factor, but that is straight forward.

Thanks for any assistance.

[JeteMc]

Made a couple of changes, highlighted in orange.
1) Put dates in row 3, then applied the formatting 'mmm' to the cells
2) Inserted a helper column (A), which may be moved and/or hidden for aesthetic purposes, populated using: =SUM(D$8:D8)
Then populated row 8 using the array entered formula*:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER (BEFORE copying across). You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.