Help with Formula for Budget Spread
Can someone help with creating a formula?
We are trying to develop a formula to help create an automatic budget spread/phasing over the year.
We have columns named for the twelve months of the year
We have a BUDGET column
We have a START DATE column
We would like to build a formula that would take a $100,000 budget and phase it out over months automatically based on the START DATE.
Example: If START DATE is in [June], BUDGET should be spread
40% in May
40% in June
10% in July
10% in August
Is something like this possible using a formula?
It would be 40 % in month prior, 40% in planned month, 10% during +1 month and 10% in +2 month
Thanks for letting me know if that is possible - and if you have a recommendation for formula to try.