Advancing the Date Function?

[Rupert T]

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]

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.

 

[Fred Smith]

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

Regards,
Fred