future dates

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.

Change the 7 to a 14 in your Weekly Date example (assumes that the
payment amount is bi-weekly, too, of course).


In article <[email protected]>,
"kevrgallagher" <[email protected]> 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.

thanks JE...I should have thought of that myself.

"JE McGimpsey" wrote:

> Change the 7 to a 14 in your Weekly Date example (assumes that the
> payment amount is bi-weekly, too, of course).
>
>
> In article <[email protected]>,
> "kevrgallagher" <[email protected]> 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.
>