consecutive dates

Hi,

how can I fill up a column (or a row) with the same day in the next month.
For example, I want to start with the date Jan 17, 2013 and fill up the cells below with Feb 17, 2013 and March 17, 2013 and so on.
Is there a formula which takes the same date in the next, or privous month?
Thank you
Raphael

Try this

PHP Code: 

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


There is! It is, assuming your original date is in cell A1:

Please Login or Register  to view this content.

Also works with -1, which gives you month prior to reference cell.

=date(year(date you want),month(date you want)+1,day(date you want))