A column showing first of the month

[ChemistB]

Arrgh, I know this is elementary but I always have trouble with Excel and dates. I want column A to have a formula such that (where A1 is initial date eg 1/1/2008)
A2 = A1 + 1 month = 2/1/08
A3 = A2 + 1 month = 3/1/08

What's the formula?

ChemistB

[VBA Noob]

Try

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

VBA Noob

[ChemistB]

Wonderful, Thanks VBA!!!!