Use the formula:
=date(year(a1),month(a1)+1,day(a1))

Regards,
Fred

"Rupert T" <Rupert wrote in message
...
Hi, I'm just looking for a function that looks at the previous cell, into
which I've typed the date (in MM-yy format), and then simply advances it
to
the next month (i.e I type in Jan-10, then the next cell automatically
displays Feb-10, and the one after Mar-10, etc). Sorry if this seems a
simple
request. Thanks