Hi!

One way (requires the Analysis ToolPak add-in be installed):

=EOMONTH(A1,0)+1

Format to suit.

Biff

"BorisS" wrote in message
...
I have a starter cell with a month/year. Is there a way other than
date(year(),month()+1,1) to get the following cell to just add one to the
month (and I need something that would continue for four years...I know
that
month 13 of any year is the next year, so am figuring that might play into
this formula).

Thx.
--
Boris