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?