Calculating months

H

hotelmasters

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?
 
T

TerryD

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.
 
J

JE McGimpsey

One way:

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

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

Lori

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