Excel formula to subtract a value based on a date condition

cmwjames - Updated on Dec 19, 2017 at 12:34 AM
I need a formula for my budget in excel.

I have the date automatically updating and I would like to use the due date for an automatic payment to change the balance on a credit card by subtracting the auto payment.