future dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
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!
 
One way:

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


kevrgallagher said:
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!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

future dates 2
calculate future date 3
Countif Function?? 3
Monday closest to today's date? 6
Looking for a formula 3
Average of Day and Time 3
Finding the right function & formula 4
Count Mondays worked in Month 6

Back
Top