Loan amortization schedule with bi-monthly payments
 

I was looking at the Loan Amortization Schedule downloaded at
http://office.microsoft.com/en-us/te...197771033.aspx and found
that the Payment Dates won't calculate for 24 payments per year (e.g. 1st and
15th payments). In stead of 1/1/2005 followed by 1/15/2005 I get 1/1/2005
followed by 2/1/2005 followed by another 2/1/2005. I believe the error stems
from the "DAY(Loan_Start)" portion from the formula, but it could come from
"(Pay_Num)*12/Num_Pmt_Per_Year" yielding 0.5 payment increments.

The original formula is:
=IF(Pay_Num<"",DATE(YEAR(Loan_Start),MONTH(Loan_S tart)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"")