# Thread: Need help to determine if a payment is due

1. ## Need help to determine if a payment is due

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.

2. There are no dates in your sample, but do you mean

=IF(AND(TODAY()>P2,T2<P2),"Y","")

3. Originally Posted by Bob Phillips
There are no dates in your sample, but do you mean

=IF(AND(TODAY()>P2,T2<P2),"Y","")
Thank you, that works. Now If I want to have it flag payments due within 7 days of today would I change it to?

=IF(AND(TODAY+7()>P2,T2<P2),"Y","")

4. P2 is the statement end date, Q2 is the due date so you need to add a check for TODAY()>=Q2-7

5. Thanks Bob, I was going to post thanks yesterday but the forum seemed down

6. Originally Posted by Emanuel Levy
...yesterday but the forum seemed down
Unfortunatley, yes. I was moving it to a new host. Hopefully that won't need to happen again for a long time.

7. Bob, I noticed one untended consequence of the formula you gave me. It still says YES to payment due with 7 days even if a payment was made after the statement close and before the due date

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•