Change the 7 to a 14 in your Weekly Date example (assumes that the
payment amount is bi-weekly, too, of course).
In article ,
"kevrgallagher" wrote:
Current formulas calculate a Monthly and Weekly future pay-off date. I'm
wondering if there is a way to calculate a bi-weekly date?
=EDATE(C20,NPER(0,C15,C10)*-1) Monthly Date
=((CEILING(H10/H15,1)-1)*7+H20) Weekly Date
Balance $5000.00
Payment $34.00
Begin Date 7/11/05
End Date ?
End date will need to be based on a bi-weekly calculation.
|