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