This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a storage yard and want to keep track of the quarterly rents.I
need to show how many days till the next rent is due. after the rent is
paid, I want to calculate how many days are left of the 90. If the rent
is 10 days past due, I want to show ...
If I enter the date paid in column A, how do I write the formula in the
next column to show if it is on time or not? You can see I am not very
skilled at this, but I love it and want to learn!
This is the layout I use now. When a client pays his rent, I would like
to enter the date they paid and have the system calculate 1. If the rent
is early, late or on time. 2. the next due date. #3. Start a countdown
for how many days are left before ...
