Try the EOMonth function. You'll need to load the Analysis ToolPak
add-in first.
It's self-explanatory, but if you get stuck you can refer to in-built
help.
Rgds,
ScottO

"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