How to Increment Date using Formula

[gatttu]

I have a row, where the adjacent cells are to be filled with dates.
I want to know how do i enter date in the first cell, so that the date values automatically get incremented, as we move towards the right side.

so that the sheet for the next month of the next quarter..i copy the row and just change the date value inthe first cell.

In anticipation.

~regd

 

[fairwinds]

Hi,

Try:

=A1+1

drag right.