I have downloaded the Loan Amortization Template from the office web site.
This helps you calculate on monthly payments. However I would like to change
the formula so that it can accurately track bi-weekly payments.
=IF(Pay_Num<"",DATE(YEAR(Loan_Start),MONTH(Loan_S tart)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"").
This is how it looks at the moment. Could anyone assist me to change it to
track bi-weekly payments. Any help appreciated.