Closed Thread
Results 1 to 4 of 4

Invoice Pay Dates?

  1. #1
    Registered User
    Join Date
    07-05-2018
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    4

    Question Invoice Pay Dates?

    So I'm trying to figure out a formula for invoice pay periods. Attached is the pay schedule I have been tasked with using, and an excerpt from the spreadsheet I need to place the formula in. I need to use both A and B to try and find C. If B is a later date than A then I know I need to use B to find C. But if A is a later date than B, I need to be using A to find C. Another part of the issue is the pay schedule. In the example spreadsheet I've attached I've put in some example dates. Lets say the due date is 10/9/2018, the pay date is 10/17/18, but if the Due date is 10/11/18, the pay date is 11/1/18. So I'm trying to find a formula that takes that into account as well.

    Any help that you guys are able to provide I would be so grateful! Thank you.
    Attached Files Attached Files
    Last edited by dogetheavenger; 07-06-2018 at 07:43 AM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Invoice Pay Dates?

    I'm not sure this is duplicated, but...
    https://www.excelforum.com/excel-for...ml#post4930125
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    07-05-2018
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Invoice Pay Dates?

    Quote Originally Posted by sandy666 View Post
    I'm not sure this is duplicated, but...
    I posted it again with more clarification and an example of what I'm trying to figure out. Seemed better than to just continue editing the original post.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,106

    Re: Invoice Pay Dates?

    Please do not post duplicate threads, continue on the same 1 until you get resolution

    I will close this 1 now, you can continue on the other 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. (Solved) Calculate due dates (Not Invoice due dates)
    By bdg724 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2015, 01:54 PM
  2. [SOLVED] Using formulas for dates on invoice tracker
    By Rebeccak28 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2015, 04:38 AM
  3. [SOLVED] Invoice highlighting due dates conditional formatting
    By toneNFFC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2015, 08:02 PM
  4. Matching an invoice to a billing period using dates
    By pauldaddyadams in forum Excel General
    Replies: 6
    Last Post: 08-26-2013, 03:05 AM
  5. highlight passed due invoice dates
    By Loveabull in forum Excel General
    Replies: 1
    Last Post: 02-18-2013, 02:02 PM
  6. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  7. saving dates\invoice numbers
    By R S via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 04-06-2005, 07:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1