future dates

One way:

=H20+7*CEILING(NPER(0,H15,H10)*-1,1)

but if your interest rate is always zero, this is more efficient:


=CEILING(H10/H15,1)*7+H20

In article <[email protected]>,
"kevrgallagher" <[email protected]> wrote:

> =H20+7*NPER(0,H15,H10)*-1
>
> Weekly
>
> Total Due
>
> $745.00
>
>
> Weekly Payment
>
> $34.00
>
>
> Begin Date
>
> 7/11/05
>
>
> End Date
>
>
>
> I'm looking for this formula to always end on the same day (mon,tue, etc.)
> as it began. For example 7/11 is a Monday and I need it to end on a Monday
> in the future. If I were to run the formula now, it would end on 12/11 a
> Tuesday. Is there a way to have it end on a Monday even though it will be a
> partial payment?

JE

that almost gets me where I want to go...the formula works correctly but
does not take in to account the begin date as the start date...so essentially
I'm 1 week ahead. Any suggestions on how to correct that. I must say I
would have never thought of the ceiling formula...much appreciated!

"JE McGimpsey" wrote:

> One way:
>
> =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
>
> but if your interest rate is always zero, this is more efficient:
>
>
> =CEILING(H10/H15,1)*7+H20
>
> In article <[email protected]>,
> "kevrgallagher" <[email protected]> wrote:
>
> > =H20+7*NPER(0,H15,H10)*-1
> >
> > Weekly
> >
> > Total Due
> >
> > $745.00
> >
> >
> > Weekly Payment
> >
> > $34.00
> >
> >
> > Begin Date
> >
> > 7/11/05
> >
> >
> > End Date
> >
> >
> >
> > I'm looking for this formula to always end on the same day (mon,tue, etc.)
> > as it began. For example 7/11 is a Monday and I need it to end on a Monday
> > in the future. If I were to run the formula now, it would end on 12/11 a
> > Tuesday. Is there a way to have it end on a Monday even though it will be a
> > partial payment?
>

One way:

=((CEILING(H10/H15,1)-1)*7+H20


In article <[email protected]>,
"kevrgallagher" <[email protected]> wrote:

> that almost gets me where I want to go...the formula works correctly but
> does not take in to account the begin date as the start date...so essentially
> I'm 1 week ahead. Any suggestions on how to correct that. I must say I
> would have never thought of the ceiling formula...much appreciated!
>
> "JE McGimpsey" wrote:
>
> > One way:
> >
> > =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
> >
> > but if your interest rate is always zero, this is more efficient:
> >
> >
> > =CEILING(H10/H15,1)*7+H20

thanks JE...that answered all of my questions!

"JE McGimpsey" wrote:

> One way:
>
> =((CEILING(H10/H15,1)-1)*7+H20
>
>
> In article <[email protected]>,
> "kevrgallagher" <[email protected]> wrote:
>
> > that almost gets me where I want to go...the formula works correctly but
> > does not take in to account the begin date as the start date...so essentially
> > I'm 1 week ahead. Any suggestions on how to correct that. I must say I
> > would have never thought of the ceiling formula...much appreciated!
> >
> > "JE McGimpsey" wrote:
> >
> > > One way:
> > >
> > > =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
> > >
> > > but if your interest rate is always zero, this is more efficient:
> > >
> > >
> > > =CEILING(H10/H15,1)*7+H20
>

=H20+7*NPER(0,H15,H10)*-1

Weekly

Total Due

$745.00


Weekly Payment

$34.00


Begin Date

7/11/05


End Date



I'm looking for this formula to always end on the same day (mon,tue, etc.)
as it began. For example 7/11 is a Monday and I need it to end on a Monday
in the future. If I were to run the formula now, it would end on 12/11 a
Tuesday. Is there a way to have it end on a Monday even though it will be a
partial payment?

One way:

=H20+7*CEILING(NPER(0,H15,H10)*-1,1)

but if your interest rate is always zero, this is more efficient:


=CEILING(H10/H15,1)*7+H20

In article <[email protected]>,
"kevrgallagher" <[email protected]> wrote:

> =H20+7*NPER(0,H15,H10)*-1
>
> Weekly
>
> Total Due
>
> $745.00
>
>
> Weekly Payment
>
> $34.00
>
>
> Begin Date
>
> 7/11/05
>
>
> End Date
>
>
>
> I'm looking for this formula to always end on the same day (mon,tue, etc.)
> as it began. For example 7/11 is a Monday and I need it to end on a Monday
> in the future. If I were to run the formula now, it would end on 12/11 a
> Tuesday. Is there a way to have it end on a Monday even though it will be a
> partial payment?

JE

that almost gets me where I want to go...the formula works correctly but
does not take in to account the begin date as the start date...so essentially
I'm 1 week ahead. Any suggestions on how to correct that. I must say I
would have never thought of the ceiling formula...much appreciated!

"JE McGimpsey" wrote:

> One way:
>
> =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
>
> but if your interest rate is always zero, this is more efficient:
>
>
> =CEILING(H10/H15,1)*7+H20
>
> In article <[email protected]>,
> "kevrgallagher" <[email protected]> wrote:
>
> > =H20+7*NPER(0,H15,H10)*-1
> >
> > Weekly
> >
> > Total Due
> >
> > $745.00
> >
> >
> > Weekly Payment
> >
> > $34.00
> >
> >
> > Begin Date
> >
> > 7/11/05
> >
> >
> > End Date
> >
> >
> >
> > I'm looking for this formula to always end on the same day (mon,tue, etc.)
> > as it began. For example 7/11 is a Monday and I need it to end on a Monday
> > in the future. If I were to run the formula now, it would end on 12/11 a
> > Tuesday. Is there a way to have it end on a Monday even though it will be a
> > partial payment?
>

One way:

=((CEILING(H10/H15,1)-1)*7+H20


In article <[email protected]>,
"kevrgallagher" <[email protected]> wrote:

> that almost gets me where I want to go...the formula works correctly but
> does not take in to account the begin date as the start date...so essentially
> I'm 1 week ahead. Any suggestions on how to correct that. I must say I
> would have never thought of the ceiling formula...much appreciated!
>
> "JE McGimpsey" wrote:
>
> > One way:
> >
> > =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
> >
> > but if your interest rate is always zero, this is more efficient:
> >
> >
> > =CEILING(H10/H15,1)*7+H20

thanks JE...that answered all of my questions!

"JE McGimpsey" wrote:

> One way:
>
> =((CEILING(H10/H15,1)-1)*7+H20
>
>
> In article <[email protected]>,
> "kevrgallagher" <[email protected]> wrote:
>
> > that almost gets me where I want to go...the formula works correctly but
> > does not take in to account the begin date as the start date...so essentially
> > I'm 1 week ahead. Any suggestions on how to correct that. I must say I
> > would have never thought of the ceiling formula...much appreciated!
> >
> > "JE McGimpsey" wrote:
> >
> > > One way:
> > >
> > > =H20+7*CEILING(NPER(0,H15,H10)*-1,1)
> > >
> > > but if your interest rate is always zero, this is more efficient:
> > >
> > >
> > > =CEILING(H10/H15,1)*7+H20
>