+ Reply to Thread
Results 1 to 8 of 8

Calculating next due date for rental euipment.

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Angry Calculating next due date for rental euipment.

    I have a contract start date. The payment is due every seven days. I have entered the start date. i need the "next due date" to automatically calculate in the "due date column". here is my problem if a customer has a due date say on 2/15/2014 his next due date should be 2/22/2014. regardless if he pays on the 14th or 21st. i need this date to change each time a payment is made.?????????

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Calculating next due date for rental euipment.

    Not sure I understand. If start date is a Saturday should the next due date be the next Saturday after today. You say it needs to change each time a payment is made - what would it change to if it's not the next Saturday after today?

    How is your data set up?
    Audere est facere

  3. #3
    Registered User
    Join Date
    02-15-2014
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Calculating next due date for rental euipment.

    Thanks for replying maybe i was clear enough. here is an example. Payments are set up on a weekly basis (every 7 days)


    A2 B2 C2 D2 E2 F2 G2 H2 I2 J2
    todays name contract financed payment date # payments Total Balance Due Date
    date date Amt Amt payment made made Paid
    -------------------------------------------------------------------------------------------------------------------------------------------------
    2/3/2014 John 2/3/2014 $1070 $20.57 2/3/2014 1 $20.57 1049 2/10/2014



    So as we can see, John's next due date is 2/10/2014. Even if John comes in on 2/7/2014 and makes a payment his next due date should be 7 days from 2/10/2014 (2/17/2014). NOT 7 days from "date payment made. As well if John comes in and pays late on 2/12/2014 his next due date should still remain at 2/17/2014.

    Hope this helps.

  4. #4
    Registered User
    Join Date
    02-15-2014
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Calculating next due date for rental euipment.

    hmmmmmm that didn't turn out the way it was written

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: Calculating next due date for rental euipment.

    Next due date = J2+7
    ?

  6. #6
    Registered User
    Join Date
    02-15-2014
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Calculating next due date for rental euipment.

    A2 = todays date
    B2= Customer Name
    C2=Contract date
    D2=Amount financed
    E2= Payment Amount
    F2= Payment Date
    G2= # payments Made
    H2= Total Payments
    I2= Balance
    J2= Due Date


    A2 B2 C2 D2 E2 F2 G2 H2 I2 J2
    ----------------------------------------------------------------------------------------
    2/3/2014 John 2/3/2014 $1070 $20.57 2/3/2014 1 $20.57 1049 2/10/2014

    So as we can see, John's next due date is 2/10/2014. Even if John comes in on 2/7/2014 and makes a payment his next due date should be 7 days from 2/10/2014 (2/17/2014). NOT 7 days from "date payment made. As well if John comes in and pays late on 2/12/2014 his next due date should still remain at 2/17/2014.

    Hope this helps


    -------------------------------------------------------------------------------------------------------------------------------------------------
    2/3/2014 John 2/3/2014 $1070 $20.57 2/3/2014 1 $20.57 1049 2/10/2014

  7. #7
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Calculating next due date for rental euipment.

    So isn't the Due date determined by the number of payments made so far?

    =C2+7*G2

  8. #8
    Registered User
    Join Date
    02-15-2014
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Calculating next due date for rental euipment.

    daddylonglegs, Thanks that worked!!!!!!!!! sometimes after creating so many formulas i try and oversimplify a simple fix!!!

+ 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: 7
    Last Post: 10-13-2013, 05:11 PM
  2. Calculate Rental Cost With Varying Rates Based On Rental Days
    By jmenh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2013, 03:17 PM
  3. Replies: 6
    Last Post: 09-06-2005, 03:05 AM
  4. Replies: 6
    Last Post: 09-05-2005, 10:05 PM
  5. Replies: 6
    Last Post: 06-04-2005, 07:05 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