date formula
hi,
i've built a loan amortization schedule with payments due semi-annually. my
problem is that the payment must be on the same day of the 6th and 12th
month.
for example payments due 2/12/05 and 8/12/05 or 9/23/05 and 3/23/06. the
problem is that months have 30 or 31 days and then there's february and leap
years too. is there a way to program this function so that manual entry
payment dates can be eliminated?
tia
dennis
|