To get the next date 6 months out, use:

=date(year(a1),month(a1)+6,day(a1))

Excel is smart enough to roll over to the next year if you're starting in
months from Jul to Dec.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"dennis" wrote in message
news:NHcPd.40226$EG1.14351@lakeread04...
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