Another "working with dates ?"
 

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
giffer

Another "working with dates ?"
 

Hi

Without any formula:
Enter 1st date into A1
Select the range A1:A200
From Edit meni, select FillSeries, 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 Laanemets


"giffer" wrote in message
ups.com...
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
giffer

Another "working with dates ?"
 

Hi!

Try this in A2 and copy down as needed:

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

Biff

"giffer" wrote in message
ups.com...
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
giffer

Another "working with dates ?"
 

Thank you Biff and Arvi. Both formulas work great.
Giffer