Forum Discussion
Joshua Sorensen
Sep 08, 2017Copper Contributor
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
Sort By
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.