+ Reply to Thread
Results 1 to 3 of 3

Calculating Due Date from various Terms66

  1. #1
    Registered User
    Join Date
    06-27-2017
    Location
    Virginia Beach, VA
    MS-Off Ver
    2013
    Posts
    2

    Calculating Due Date from various Terms66

    I am trying to create a function in VBA that calculates various due dates of invoices for different payment terms.

    I am trying to figure out how to program some of the more complicated terms.

    For example one company pays us on the 10th and the 25th of the month.

    If the invoice is dated after the 25th but before the 10th of the next month then they will pay on the 25th of the next month
    If the invoice is dated after the 10th but on or before the 25th then they will pay on the 10th of the next month.

    I can't figure out how to code something like that.

    THanks

  2. #2
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Calculating Due Date from various Terms66

    Hi There, I am trying but its not working for some reason. The code I am trying is below. please note that I am a rookie in coding and below is not a working solution but i thought of sharing it so that if it can strike some hint to you. Also you mentioned only one condition as a sample so the function i am trying to build is around those condition only

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-27-2017
    Location
    Virginia Beach, VA
    MS-Off Ver
    2013
    Posts
    2

    Re: Calculating Due Date from various Terms66

    On line 2 you have Year(InvoiceDate).

    Shouldn't that be Year = Year(InvoiceDate)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 09-06-2005, 03:05 AM
  2. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 02:05 AM
  3. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 12:05 AM
  5. Replies: 6
    Last Post: 09-05-2005, 11:05 PM
  6. Replies: 6
    Last Post: 09-05-2005, 10:05 PM
  7. Replies: 6
    Last Post: 06-04-2005, 07:05 PM

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