To add 1 month, but cater for that month having less days and not
over-spilling,

=MIN(DATE(YEAR(A1),MONTH(A1)+{2,1},DAY(A1)*{0,1}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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