So I need a solution, I can't see what it might be. I have some data and I need to record savings by month. The only data I have to work with is the savings total, when the contract will start, the duration of months. So I can do the total saving / contract duration, which gives me my monthly saving.
But then how do I populate these monthy savings into a table, for it to pick up only the number of months from the start date to populate?
In cell A6:
=IF(AND($D$2<=A5,EDATE($D$2,$F$2-1)>=A5),$G$2,"")
In cell A9:
=IF(AND($D$2<=A8,EDATE($D$2,$F$2)-1>=A8),$G$2,"")
In my example i've entered these formulas in cells A6 and A9 and filled them to the right. Perhaps this is similar to what you are looking for.
