Trying to Auto-Fill Months

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
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.
 
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.
 
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.
Click to expand...

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!
 
Back
Top