Thread: date formula
View Single Post
  #1   Report Post  
dennis
 
Posts: n/a
Default 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