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? |
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 , "kevrgallagher" 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 , "kevrgallagher" 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 , "kevrgallagher" 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 , "kevrgallagher" 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 |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com