Another "working with dates ?"

[giffer]

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

[Arvi Laanemets]

Hi

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


"giffer" <lgibson_39@yahoo.com> wrote in message
news:1145643490.784641.22910@e56g2000cwe.googlegroups.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
>

[Biff]

Hi!

Try this in A2 and copy down as needed:

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

Biff

"giffer" <lgibson_39@yahoo.com> wrote in message
news:1145643490.784641.22910@e56g2000cwe.googlegroups.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
>

[giffer]

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