SOLVED

Trying to auto deduct expenses each month

Copper Contributor

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 point of reducing that amount on the 1st day of the month, I need cell E10 to replace the starting monthly amount in cell B10 and I haven't been able to figure that out as it ruins the formula since it needs something to reference.

 

JoshAbear_0-1695563453681.png

JoshAbear_1-1695563468570.png

 

I am trying to do this without having to list each month out if possible.

 

Thanks,

Josh

 

2 Replies
best response confirmed by SergeiBaklan (MVP)
Solution

@JoshAbear 

I'd enter the start date in a cell, for example A10. You can then use the formula

=B10-DATEDIF(A10,TODAY(),"m")*C10

HansVogelaar_0-1695564106252.png

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!
1 best response

Accepted Solutions
best response confirmed by SergeiBaklan (MVP)
Solution

@JoshAbear 

I'd enter the start date in a cell, for example A10. You can then use the formula

=B10-DATEDIF(A10,TODAY(),"m")*C10

HansVogelaar_0-1695564106252.png

View solution in original post