Forum Discussion
Loan Amortization Template
I am having trouble with the amount of payments per year cell. If I wish to pay 12 payments a year (monthly) the calculations are reasonably accurate, however if I wish to pay fortnightly or weekly, ...
I am having the same problem, the template seems to default the date to every month, even if I am making payments every two weeks. I would like to change the date formula but cannot figure out how it should be coded to factor in and show the date of the payment on an every other week schedule versus monthly.longtan2