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.