AutoFill Only Weekdays in Excel (2 Quick Ways)

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

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
Phản hồi nội tuyến
Xem tất cả bình luận