Formula to auto fill in following month.

M

MagnoliaSouth

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

Biff

Need more info.

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

Biff
 
M

MagnoliaSouth

Fill how many cells with months? Up to December? What if the user enters
December in B2?
Click to expand...
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 are:

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

Fred Smith

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

Teethless mama

Try this

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

copy from B8 to B14 and so on...
 
B

Biff

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
 
M

MagnoliaSouth

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