Trying to Auto-Fill Months

[Bob]

I'm trying to set up a spreadsheet that will do the
following:
I input a single month in the contract beginning field,
then I want the worksheet to auto-fill a column of 12
blocks with a list of months, starting with the one from
the contract begin field. I'm a fairly new user. Thank
you in advance.

 

[Bob]

I managed to figure out a way to do it with EOMONTH. My
formula was =EOMONTH(<target cell>,x) where <target cell>
was where the original month would be placed, then each
month in turn had a number (x) from 0 to 11, to give me
the 12 month column no matter what month was started with.

 

[Norman Harker]

Hi Bob!

With the month input in A1 as (e.g) March

And first month required in A4

A4:
=TEXT(DATE(2004,VLOOKUP(A1,{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,FALSE),1),"mmmm")

A5:
=TEXT(DATE(2004,VLOOKUP(A4,{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,FALSE)+1,1),"mmmm")

Copy down as far as you like.

But it is easier if you input a date in A1 which you might format as
mmmm. You can then use DATE or EDATE (Analysis ToolPak) to create your
series.

 

[Domenic]

I'm trying to set up a spreadsheet that will do the
following:
I input a single month in the contract beginning field,
then I want the worksheet to auto-fill a column of 12
blocks with a list of months, starting with the one from
the contract begin field. I'm a fairly new user. Thank
you in advance.

Assuming that you want month only and not day/month/year, with the date in
in cell A1, put the following formula in A2 and copy down to A12:

=IF(A1="","",DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))

custom format as "mmmm"

If you want the day/month/year, then:

=IF(A1<>"",IF(DAY($A$1)>DAY(DATE(YEAR(A1),MONTH(A1)+2,1)-1),DATE(YEAR(A1),MO
NTH(A1)+2,1)-1,DATE(YEAR(A1),MONTH(A1)+1,DAY($A$1))),"")

format cells

Hope this helps!