Bi-weekly due dates for loan repayments

[PohTek]

Hi. Currently doing a program to calculate the loan repayments with due date, principal, interest and fortnight amortization. May I ask how do I calculate the repayment type to bi-weekly or fortnightly and populate the schedule of due dates bi-weekly automatically from the start date of payment. I only know for the weekly calculation i.e. DueDate = DateAdd("ww", intNumber, Me!Date)

Thank you so much in advance.

 

[combo]

For bi-weekly: DueDate = intNumber * 14 * Me!Date
For fixed periods, in opposite to months, simple math can be used.

combo

 

[dhookom]

Do you need all of the payment calculation functionality in addition to the scheduling piece?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016