software

Hi,
I want to create a list of dates one month apart from cell A1 thru
A200. In cell A1, I have the date of April 1, 2006. I need a formula
that copies A1 and adds one month to cell A2 thru A200.
Example
A1 April 1, 2006
A2 May 1, 2006
A3 June 1, 2006
A4 July 1 2006

Any suggestions will be appreciated
gifferHi

Without any formula:
Enter 1st date into A1
Select the range A1:A200
From Edit meni, select Fillgt;Series, set Date Unit to Month, and click OK

With formula:
Enter 1st date into A1
Into A2, enter the formula
=DATE(YEAR(A1),MONTH(A1) 1,1)
, and format it as date.
Copy A2 down until to A200.Arvi Laanemetsquot;gifferquot; gt; wrote in message ups.com...
gt; Hi,
gt; I want to create a list of dates one month apart from cell A1 thru
gt; A200. In cell A1, I have the date of April 1, 2006. I need a formula
gt; that copies A1 and adds one month to cell A2 thru A200.
gt; Example
gt; A1 April 1, 2006
gt; A2 May 1, 2006
gt; A3 June 1, 2006
gt; A4 July 1 2006
gt;
gt; Any suggestions will be appreciated
gt; giffer
gt;
Hi!

Try this in A2 and copy down as needed:

=DATE(YEAR(A1),MONTH(A1) 1,1)

Biff

quot;gifferquot; gt; wrote in message ups.com...
gt; Hi,
gt; I want to create a list of dates one month apart from cell A1 thru
gt; A200. In cell A1, I have the date of April 1, 2006. I need a formula
gt; that copies A1 and adds one month to cell A2 thru A200.
gt; Example
gt; A1 April 1, 2006
gt; A2 May 1, 2006
gt; A3 June 1, 2006
gt; A4 July 1 2006
gt;
gt; Any suggestions will be appreciated
gt; giffer
gt;
Thank you Biff and Arvi. Both formulas work great.
Giffer