Microsoft Excel Tutorial: Fill Certain Weekdays in Excel such as Monday, Weds, Friday.

Welcome to another episode of the MrExcel podcast, where we dive into all things Excel. In today’s episode, we’ll be tackling a question from one of our seminar attendees in Mobile, Alabama. They asked about filling in dates for Mondays, Wednesdays, and Fridays. While most people know about the fill weekdays option, not many are aware of the trick to fill in specific weekdays. But don’t worry, I’ve got you covered.

To fill in the desired dates, we’ll be using the WORKDAY.INTL function. This function has a secret, undocumented weekend argument that allows us to specify which days are considered weekends. By using this function, we can easily fill in the dates for Mondays, Wednesdays, and Fridays. All we have to do is enter the start date, the number of workdays we want to add, and the weekend argument in the correct format.

The weekend argument uses a /”7 binary digits/” format, with each digit representing a day of the week. A zero means that day is not considered a weekend, while a one means it is. So for our example, we would enter /”0110100/” to indicate that Monday, Wednesday, and Friday are not weekends. And just like that, we have our desired dates filled in. But remember, the key is to use the WORKDAY.INTL function, not the regular WORKDAY function. So next time you need to fill in specific weekdays, give this trick a try.

Thanks for tuning in to this episode of the MrExcel podcast. I hope you found this tip helpful and will use it in your own Excel projects. Don’t forget to subscribe to our channel for more Excel tips and tricks, and I’ll see you in the next episode!/”

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoft
#microsoftexcel
#exceltips
#exceltricks
#excelhacks
#excelformula
#excelformulasandfunctions
#evergreenhits

This video answers these common search terms:
how to excel calculate days after date networkdays
what does the networkdays formula in excel calculate
how to do a weekday formula in excel
how to return a weekday in excel
how to set weekdaydates in excel formula
how to count workdays between two dates in excel
how to do the networkdays in excel
how to use workday.intl function in excel
how to use workdays excel
excel fill specific weekdays
fill weekdays excluding weekends excel
populate weekdays in excel
excel fill only monday wednesday friday
excel autofill weekdays
excel skip weekends in autofill

Table of Contents:
(00:00) Using right click to fill Weekdays in Excel
(00:16) Filling specific days (Monday, Wednesday, Friday)
(00:26) Using NETWORKDAYS and WORKDAY,INTL function
(00:36) Explaining the undocumented weekend argument
(00:48) Formatting the weekend argument
(01:08) Copy formula with fill handle
(01:18) Clicking Like really helps the algorithm

There is a well-known trick in Excel to fill just weekdays. But what if your work week is not Monday through Friday? Today, a trick with WORKDAY.INTL in Excel to fill Monday, Wednesday, Friday.

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1154085/

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