In the worksheet with Auto Fill Options, just fill in the weekdays:
- Drag the fill handle to the desired end dates, as shown in the screenshot:
- Then, in the right-hand corner, click the Auto Fill Options button and select the Fill Weekdays option, as seen in the screenshot:
- As you can see, the spreadsheet is now solely filled with weekdays.
Share a personalized message with your friends.