Remember Me?

#1
April 22nd 05, 08:54 PM
 2ndchinv Posts: n/a
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
April 22nd 05, 10:12 PM
 LanceB Posts: n/a

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
 LanceB Posts: n/a

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
 2ndchinv Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Greegan Excel Worksheet Functions 7 March 13th 05 01:56 PM krempin Excel Worksheet Functions 2 February 9th 05 09:43 PM Coddie Excel Worksheet Functions 4 January 18th 05 03:31 PM Charlie Excel Worksheet Functions 4 December 7th 04 05:50 PM Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM

All times are GMT +1. The time now is 10:37 AM.