Emanuel Levy
New member
- Joined
- Jan 14, 2013
- Messages
- 19
- Reaction score
- 0
- Points
- 0
Howdy! I'm working on a credit card payment spreadsheet and I'm trying to figure out how to have it indicate what payments are due for the month.
Right now column P have the statement ending date and column Q has the due date. I want to have a Y in column V is a payment is due. The way I'm determining that is if today's date is after the statement close date and the last payment date is is prior to the statement close date.
This is because I make multiple payments a month.
Right now column P have the statement ending date and column Q has the due date. I want to have a Y in column V is a payment is due. The way I'm determining that is if today's date is after the statement close date and the last payment date is is prior to the statement close date.
This is because I make multiple payments a month.