ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   future dates (https://www.excelbanter.com/excel-worksheet-functions/35360-future-dates.html)

kevrgallagher

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.

JE McGimpsey

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.


kevrgallagher

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