Hi Boris

If the day of the month in the starting cell is always going to be less
than29, then
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

If it is always going to be the last day of the month, then use
=DATE(YEAR(A1),MONTH(A1)+2,0)

--
Regards
Roger Govier



"BorisS" wrote in message
...
what's the simplest formula to add exactly a month to the next cell of a
series? In other words, enter a beginning date, and then have the formula
next to it take that date and add one month. Thanks.

--
Boris