Advancing the Date Function?

  • Thread starter Thread starter Rupert T
  • Start date Start date
R

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
 
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.
 
Back
Top