In this short video, I will show you how to quickly autofill only the weekdays in a column in Excel.

This can easily be done using the Fill series option (which is an inbuilt functionality in Excel). while this is quick and easy one drawback of this method is that it would always consider Saturday and Sunday as the weekend days.

If you want more control on the days that you want to fill in a column in Excel, you can use the WEEKDAY formula method that I also cover in the video

00:00 Intro
00:13 Autofill Weekday Dates Using AutoFill Options
01:40 Autofill Weekday Dates Using WEEKDAY formula

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - [ Ссылка ]

✅ Free Excel Course (Basic to Advanced) - [ Ссылка ]
✅ Free Dashboard Course - [ Ссылка ]
✅ Free VBA course - [ Ссылка ]
✅ Free Power Query Course - [ Ссылка ]
✅ Best Excel Books: [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

#Excel #ExcelTips #ExcelTutorial

свернуть