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
>