|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 22nd 05, 08:54 PM
|
|||
|
|||
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. 
|
| Ads |
|
#2
April 22nd 05, 10:12 PM
|
|||
|
|||
|
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
April 22nd 05, 11:01 PM
|
|||
|
|||
|
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
April 24th 05, 10:24 PM
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want to select the first blank cell in column A | Greegan | Excel Worksheet Functions | 7 | March 13th 05 12:56 PM |
| In MS Excel, how do I fill in a column with the same cell from se. | krempin | Excel Worksheet Functions | 2 | February 9th 05 08:43 PM |
| How do you copy a cell formula down a column without displaying n. | Coddie | Excel Worksheet Functions | 4 | January 18th 05 02:31 PM |
| VBA 'deleting row if a cell in column A is a zero. | Charlie | Excel Worksheet Functions | 4 | December 7th 04 04:50 PM |
| GET.CELL | Biff | Excel Worksheet Functions | 2 | November 24th 04 07:16 PM |
Linear Mode
