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 05/01/21-07/2021 & so on. It is specifically to fill in each Tuesday & Thursday of the week as the classes only run on these days.
1 Reply
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
