thanks all for eomonth suggetions. I had found it right before looking here.
Does this mean that if my users do not have the toolpack, this function will
not appear properly?
--
Boris


"ScottO" wrote:

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