Advancing the Date Function?
 

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

Advancing the Date Function?
 

As long as you typed in a real date, the format won't matter to excel -- it will
matter to you!

But if you have June 1, 2010 in A1 (formatted to 06-10), you can use this in B1:

=date(year(a1),month(a1)+1,1)
and format it the way you like.





Rupert T wrote:

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

--

Dave Peterson

Advancing the Date Function?
 

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