Excel formula to subtract a value based on a date condition

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.