Nov 17 2021 08:35 AM - edited Nov 17 2021 08:35 AM
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.
Nov 17 2021 09:45 AM - edited Nov 17 2021 09:45 AM
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