January-07
February-07
March-07
April-07
May-07
June-07
July-07
August-07
September-07
October-07
November-07
December-07
January-08
February-08
March-08
April-08
May-08
June-08
July-08
August-08
September-08
October-08
November-08
December-08
January-09
February-09
March-09
April-09
May-09
June-09
July-09
August-09
September-09
October-09
October-09
November-09
December-09
January-10
February-10
March-10
April-10
May-10
June-10
July-10
August-10
September-10
October-10
November-10
December-10
January-11
February-11
March-11
April-11
May-11
June-11
July-11
August-11
September-11
October-11
November-11
December-11
January-12
February-12
March-12
April-12
May-12
June-12
July-12
August-12
September-12
October-12
November-12
December-12
January-13
February-13
March-13

Put a date in a cell with the middle of the month Example 01/15/07. then
format that month to diisplay as you need. In the nexth cell = that cell +30
and it will change to the next month. Also you cna put in Apr, MAy, etc in
adjoining cells and highlight and drag and it will put the next month in
sequense in either next or if you gobackwards the previous month.

"hotelmasters" wrote:

If i have the name of a month in a cell (i.e. "April") can i then have
another cell calculate itself to display the next or previous month
automatically (ie. "May" or "March") by using a formula?