Forum Discussion

Joshua Sorensen's avatar
Joshua Sorensen
Copper Contributor
Sep 08, 2017

Excel Date Autofill

I am trying to create a list of days/dates starting on Sunday, January 5, 2014, and autofill one (or if possible, for a period, two) Sunday rows, one Wednesday row, and one Saturday row up through the end of 2017. Thanks for any and all help!

1 Reply

  • Hi Joshua,

     

    Perhaps the easiest way is to fill list separately for each day of the week using Home->Fill-Series with step 7 and after that sort entire list by date.

Resources