Forum Discussion
Solved
Auto debit payment on or after set date of month
I need a formula that will input into a cell a negative number and keep it that way until a set date has arrived and then change it to a positive number and keep it positive thereafter. For instance...
- I would think you mean either $0.00 or the $9.99 fee (or whatever it is), not negative same amount switching to positive.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
I would think you mean either $0.00 or the $9.99 fee (or whatever it is), not negative same amount switching to positive.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
- I didn' think to give the due dates their own column. I'll give this a try and see how well it works for my needs. Thank you!
- It appears to be working. I have several other payments that are auto-debited from my banking account and have applied this technique & formula, and so far, so good. Thank you, again. (The reason I want to show a negative number before the payment is auto-debited from my account is because I also add all my payments for the month(s) ahead to stay within my budget.) Thanks!
