Less than 1 week –
Less than 10 hrs/week –
I need an excel formula to create a payment schedule for some contacts. I DO NOT want this task done manually. It must be a formula that I can copy and paste.
Please look at the attached spreadsheet.
(For this example I am talking about row 4)
The first thing the formula needs to do is look at the installment date in column "Q"
If the First Installment Date in column"Q" is between the date in cell ...