Forum Discussion
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 I replicated the model from your picture and came up with the following formula, eliminating all the IF's and TRUE/FALSE checks. Though, the result may be slightly different for partial years, due to rounding.
The file is attached.
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.
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.
