Excel Date Mastery Fill Monday Weds Fri Dates Episode 2256

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=DGo89RBSAXI

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-... • #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...

#############################

New on site