Excel 2003 - Increasing a Date by 30

[DaveInPitt]

Hello Everyone - I have a spreadsheet with a Date column. I want to increase the date, every 30 days for the remaining rows. I have attached an example. Any suggestions?

[rory]

That's not every 30 days. Do you mean you want the month to increase by 1? If so:
=DATE(year(A1),month(A1)+1,day(A1))
in A2 (assuming first data in A1) and copy down as required.

[DaveInPitt]

Thanks Rory, yes, you are correct I want to increase the Month by 1. Does A1 represent the cell number?

[rory]

Yes, A1 is whichever cell has the first date in.