Try this:

Enter this formula in B2:

=IF(D5="","",TEXT(D5,"mmmm"))

Enter this formula in B8 and copy it to B14, 20, 26, 32, 38, 44, 50, 56, 62,
68:

=IF(B2="","",TEXT(DATEVALUE(B2&" "&1)+32,"mmmm"))

Biff

"MagnoliaSouth" wrote in message
...
Fill how many cells with months? Up to December? What if the user enters
December in B2?
I just need a formula to put in B8 based on what was entered in B2. If the
user enters December in B2, then I would want the following month entered
in
B8, which is naturally January.

I'm not sure I understand why it matters how many months, because I plan
on
modifying each cell I'm going to use, to follow the example. However, if
for
some reason it does matter, I need twelve months and the cells a

B2 is where the user enters the month. Let's say it's November.
B8 would then automatically become December
B14 becomes January
B20 becomes February
and so on (B26,B32,B38,B44,B50,B56,B62) until B68, which then would become
October.

The sheet is entirely dependent on what the user decides the first month
should be of any 12 month cycle.

Now on the other hand, there is a cell (D5) where the user will enter an
actual start date, which is a full date such as 11/22/06. Would it be
easier
for B2 to extract the month based on that date?

Although the only problem with that is that the rest of the months
(B8-B68)
would still need to be automatically filled in, again based on what is
entered in B2.

I appreciate your help and your asking for further information. I
apologize
if it wasn't clear.