AutoFill Only Weekdays in Excel (2 Quick Ways)

AutoFill Only Weekdays in Excel (2 Quick Ways)

HomeOther ContentAutoFill Only Weekdays in Excel (2 Quick Ways)
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
0 Views
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 – https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
Free VBA course – https://bit.ly/excel-vba-course
Free Power Query Course – https://bit.ly/power-query-course
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.