On Fri, 11 Feb 2005 22:08:55 -0600, "Fred Smith" wrote:

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.

Try 8/30/2005 in A1.


--ron