Autofill weekly dates in Excel (bi-weekly or any date series) #msexcel #excel #dataanalysis

These shits r not working in my excel, series option is disabled and can’t access it , drag down doesn’t work other than copy it down

In case anyone else is still wondering: you're supposed to click and drag holding RIGHT CLICK. If you used LEFT CLICK, you don't get the right context menu.

If you don't have the option, it is possibly in the top. Go to the "Home" tab and in the "Editing" section, select "Fill" and then "Series..." from there you can change it. It might only work for the selected cells and you might have to redo the action each time.

there is no "series" in drop down

I don't get that option when I drag and fill, I only get a box with autofill options and not a series option

Very helpful - exactly what I needed (weekly increment)! Thanks!