Forum Discussion
ScottN1295
Jul 12, 2024Copper Contributor
How to evenly distribute an amount across multiple periods that are variables
I have a total dollar amount that needs to be spread over multiple periods. The periods are tied to the construction of a facility. As such, the timeline needs to be easily adjusted in case the const...
ScottN1295
Jul 13, 2024Copper Contributor
Riny_van_Eekelen thanks for the reply.
I noticed in the model you built the Yearly Periods at the top are as of 1/1/XXXX instead of 12/31/XXXX. When I used your formula with the correct period times the formula didn't work.
Note - the only change I made to your excel was the day of the Yearly Periods at the top to conform to 12/31/XXXX.
Riny_van_Eekelen
Jul 14, 2024Platinum Contributor
ScottN1295 But is essential for the formulas to work that you leave the dates in the header as the were. Otherwise the formulas have to be re-written with a different, though similar, logic.