Drag date to increment by 7 days

  • Thread starter Thread starter Gianni
  • Start date Start date
G

Gianni

Is there a way to drag down a date like

08/21/11

to get

08/28/11

?

Thanks
 
hey Gianni,

use series option
press short key Alt + E+ I+ S
then step value 7
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dragging without incrementing 8
Arrange data based on two conditions 2
Suming Up Time over the course of days 1
Is there a way to see the history of dates a file was modified? 1
YEAR MONTH DAYS COUNTER 2
Sort not working as expected 2
Formula to display Count of Days in given month, using list of Startand End Dates 1
Start Date + 7 5

Back
Top