Forum Discussion
Solved
Trying to auto deduct expenses each month
I'm trying to have a starting monthly amount (Cell B10 $33,526) and have it reduce X amount (Cell C10 $628.83) every month on a set day (Cell E10 $32,869.95). While I've been able to get it to a poin...
I'd enter the start date in a cell, for example A10. You can then use the formula
=B10-DATEDIF(A10,TODAY(),"m")*C10
I'd enter the start date in a cell, for example A10. You can then use the formula
=B10-DATEDIF(A10,TODAY(),"m")*C10
That worked actually. I had to make same slight adjustments to account for interest rate that I didn't list in my initial posting but I think it works. Appreciate you!