ron, wouldn't there be a problem only if one were to begin their series with
the following 4:
8/29,
8/30,
8/31
or 2/29 ?

All others (limited test) seem to work..
TIA,


"Ron Rosenfeld" wrote in message
...
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