Forum Discussion
MONTHLY SAVINGS TRACKER
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 d...
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.