Programing date field showing when Payment should be done and that can change depending on date
Hi, I would like to calculate a field that shows when next payment (each week, month, etc) should be made...
I have a "First Payment Field" which is entered manually and I would like to have a "Next payment" field that can be updated automatically depending on current day.
First payment: Oct 10, 2014
Next payment: Oct 17, 2014 (First Payment +7)
When current day = Oct 17, 2014 I would like Next payment to change to Oct 24, 2014 (Next Payment +7) and then When current date is 24th, Next payment should be 31st, and so on.