Results 1 to 7 of 7

Thread: Need help to determine if a payment is due

  1. #1
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0

    Need help to determine if a payment is due



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

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

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

  3. #3
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    Quote Originally Posted by Bob Phillips View Post
    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. #4
    P2 is the statement end date, Q2 is the due date so you need to add a check for TODAY()>=Q2-7

  5. #5
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    Thanks Bob, I was going to post thanks yesterday but the forum seemed down

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by Emanuel Levy View Post
    ...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.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  7. #7
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0
    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
    Attached Files Attached Files

Posting Permissions

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