How to...

[fozo]

Hello experts,

I am here needing your expert help again.

I am looking for a way to have the date auto increase 7 days when we drag/copy down the cells. For example, I have the following:

03/31/13
04/07/13
04/14/13

So, when I copy down (let say hundred cells down), the day should show 7 days apart. Is there a formula?

Thanks much.

 

[Dryver14]

if date is in A1
in A2 formula = =A1+7 and drag down

 

[fozo]

Wow, that simple? thanks much.

 

[Dryver14]

Your welcome.

Nothing is simlple until you know.