# Calculating next due date for rental euipment.

1. ## 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. ## 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?

3. ## 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
-------------------------------------------------------------------------------------------------------------------------------------------------
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. ## Re: Calculating next due date for rental euipment.

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

5. ## Re: Calculating next due date for rental euipment.

Next due date = J2+7
?

6. ## 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
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. ## 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. ## 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!!!

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