Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Populate 120 cell column with successive months entering only firs
I have a column of 120 cells I want to populate with successive months
repeating, of course, 10 times. The start month can be any month of the year. I want to be able to enter only the start month and the rest of the column will populate automatically with successive months. |
#2
|
|||
|
|||
in A1 enter the start date
in a2 enter =DATE(YEAR(a1),MONTH(a1)+1,1) copy a2 to a3 down to a120 "2ndchinv" wrote: I have a column of 120 cells I want to populate with successive months repeating, of course, 10 times. The start month can be any month of the year. I want to be able to enter only the start month and the rest of the column will populate automatically with successive months. |
#3
|
|||
|
|||
or
in A1 enter the start date In a2 =EOMONTH(a1,1) Format cells as mmmm to see just the month "LanceB" wrote: in A1 enter the start date in a2 enter =DATE(YEAR(a1),MONTH(a1)+1,1) copy a2 to a3 down to a120 "2ndchinv" wrote: I have a column of 120 cells I want to populate with successive months repeating, of course, 10 times. The start month can be any month of the year. I want to be able to enter only the start month and the rest of the column will populate automatically with successive months. |
#4
|
|||
|
|||
LanceB, your second suggestion below worked like a champ. Thanks.
"LanceB" wrote: or in A1 enter the start date In a2 =EOMONTH(a1,1) Format cells as mmmm to see just the month "LanceB" wrote: in A1 enter the start date in a2 enter =DATE(YEAR(a1),MONTH(a1)+1,1) copy a2 to a3 down to a120 "2ndchinv" wrote: I have a column of 120 cells I want to populate with successive months repeating, of course, 10 times. The start month can be any month of the year. I want to be able to enter only the start month and the rest of the column will populate automatically with successive months. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to select the first blank cell in column A | Excel Worksheet Functions | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
VBA 'deleting row if a cell in column A is a zero. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |