Need help to determine if a payment is due

Emanuel Levy

New member
Joined
Jan 14, 2013
Messages
19
Reaction score
0
Points
0
Location
Toms River, New Jersey, United States
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.
 

Attachments

  • My_debt_plan.xlsm
    26.5 KB · Views: 11

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
There are no dates in your sample, but do you mean

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

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
P2 is the statement end date, Q2 is the due date so you need to add a check for TODAY()>=Q2-7
 

Emanuel Levy

New member
Joined
Jan 14, 2013
Messages
19
Reaction score
0
Points
0
Location
Toms River, New Jersey, United States
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
 

Attachments

  • My_debt_plan_v05e.xlsm
    33 KB · Views: 7
Top