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?

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?

One way:

Previous: =TEXT(DATEVALUE("1-"&A1&"-2007")-1,"mmmm")

Next: =TEXT(DATEVALUE("1-"&A1&"-2007")+32,"mmmm")

In article ,
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?

After entering "April" you can select the cell and drag the fill
handle in the bottom right corner across or down to fill months. If
you want a formula though, try entering this:

=TEXT(DATE(0,MONTH(A1&"-0")+1,1),"mmmm")

in A2, and dragging down should, assuming the month is in A1.

On Feb 6, 2:39 pm, 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?