Formula to auto fill in following month.
 

Much thanks, in advance, to anyone who can help me. :)

Using Office 2003, I need a formula where the user enters a month for the
current cycle in cell B2, and all subsequent month cells automatically fill
in.

So say the user enters April in B2, then B8 would automatically fill in as
May, and B14 would fill in as June, and so forth.

I also need it to display the full month name and not abbreviated, such as
JUN.

Any ideas?

Formula to auto fill in following month.
 

Need more info.

Fill how many cells with months? Up to December? What if the user enters
December in B2?

Biff

"MagnoliaSouth" wrote in message
...
Much thanks, in advance, to anyone who can help me. :)

Using Office 2003, I need a formula where the user enters a month for the
current cycle in cell B2, and all subsequent month cells automatically
fill
in.

So say the user enters April in B2, then B8 would automatically fill in as
May, and B14 would fill in as June, and so forth.

I also need it to display the full month name and not abbreviated, such as
JUN.

Any ideas?

Formula to auto fill in following month.
 

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.

Formula to auto fill in following month.
 

Your "on the other hand" does make it much easier. If D5 has a date, then

B2 =d5 with a format of mmmm

b8 =date(year(d5),month(d5)+1,day(d5)) with the same format

b14 = ...month(d5)+2...

etc.

--
Regards,
Fred


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

Formula to auto fill in following month.
 

Try this

B8 =TEXT(DATE(2006,MONTH(VALUE(CONCATENATE(B2," 1, ", 2006)))+1,1),"mmmm")

copy from B8 to B14 and so on...

"MagnoliaSouth" wrote:

Much thanks, in advance, to anyone who can help me. :)

Using Office 2003, I need a formula where the user enters a month for the
current cycle in cell B2, and all subsequent month cells automatically fill
in.

So say the user enters April in B2, then B8 would automatically fill in as
May, and B14 would fill in as June, and so forth.

I also need it to display the full month name and not abbreviated, such as
JUN.

Any ideas?

Formula to auto fill in following month.
 

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.

Formula to auto fill in following month.
 

Wow. I had no idea there were so many ways to go about this. Thank you so
much to Biff, Fred and Teethless for the help. :)

Formula to auto fill in following month.
 

I'm sure Fred and Teethless will join me in thanking you for the feedback!

Biff

"MagnoliaSouth" wrote in message
...
Wow. I had no idea there were so many ways to go about this. Thank you so
much to Biff, Fred and Teethless for the help. :)