Forum Discussion
AutoFill specific days of the week only
Hello, I am fairly new to excel and want to setup a sheet to track attendance. How would I autofill only two dates each week when dragging the cell. So rather than it going 01/01/21-02/01/21 it goes ...
Hi MichaelMcIY
just enter the first four example dates, so Excel can recognize the pattern. Then select the four dates and drag it down as far as you need using the little square at the right bottom of the last cell