future dates
=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?
|