AutoFill specific days of the week only

%3CLINGO-SUB%20id%3D%22lingo-sub-2976027%22%20slang%3D%22en-US%22%3EAutoFill%20specific%20days%20of%20the%20week%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2976027%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20fairly%20new%20to%20excel%20and%20want%20to%20setup%20a%20sheet%20to%20track%20attendance.%20How%20would%20I%20autofill%20only%20two%20dates%20each%20week%20when%20dragging%20the%20cell.%20So%20rather%20than%20it%20going%2001%2F01%2F21-02%2F01%2F21%20it%20goes%2005%2F01%2F21-07%2F2021%20%26amp%3B%20so%20on.%20It%20is%20specifically%20to%20fill%20in%20each%20Tuesday%20%26amp%3B%20Thursday%20of%20the%20week%20as%20the%20classes%20only%20run%20on%20these%20days.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2976027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

Screenshot1.png      Screenshot2.png