Microsoft Excel Tutorial: Using the WORKDAY.INTL function to make sure you never schedule on a certain day of the week.

In this video, we tackle a complex scheduling problem using Excel. The question comes from Robert, who needs to schedule haircuts for a correctional facility. The challenge is that the first haircut must occur on a Saturday, and then subsequent haircuts must be scheduled every four weeks on a Saturday. But here's the catch - the barber only works on Saturdays, making it a bit more complicated to generate the schedule.

Thankfully, there is a powerful tool in Excel that can solve this problem - the WORKDAY.INTL function. This function allows you to specify a starting date and the number of workdays you want to add to that date. But the real magic happens when you define the weekend using a text string with seven binary digits. This allows you to specify any combination of weekdays and weekends, making it perfect for our situation where the barber only works on Saturdays.

But that's not all - we also have the option to define holidays using the optional fourth argument in the WORKDAY.INTL function. This comes in handy when the barber doesn't work on certain days, such as Independence Day or Christmas. By specifying these holidays, we can ensure that the schedule is accurate and takes into account any days that the barber is not available.

I love how Excel has a solution for even the most complex problems, and the WORKDAY.INTL function is a perfect example of that. It may not be obvious at first, but with a little bit of knowledge and creativity, we can use this function to generate a schedule that meets all of our requirements. And if you want to learn more about Excel and boost your skills, be sure to check out my new book, MrExcel 2022 Boosting Excel, and my courses on the Retrieve platform. Don't forget to like, subscribe, and ring the bell for more Excel tips and tricks.

Buy Bill Jelen's latest Excel book: [ Ссылка ]

You can help my channel by clicking Like or commenting below: [ Ссылка ]


#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

Join the MrExcel Message Board discussion about this video at [ Ссылка ]

This video is all about the Excel function for WORKDAY.INTL. It allows you to make sure that you are always scheduling an event to occur on a Saturday, or Tues/Thurs or Friday.
The secret here is the alternate syntax for the Weekend argument.
Table of Contents
(0:00) Find a particular Saturday in Excel
(0:25) WORKDAY introduction
(1:37) Find a particular Saturday in Excel
(2:32) Find the next Tuesday
(5:02) Find next Tuesday or Thursday
(5:46) Handling holidays
(6:58) Clicking Like really helps the algorithm

This video answers these common search terms:
Calculation using TODAY() function
Defining weekends in Excel
Excel scheduling formulas
Generating specific Saturdays from today
Haircut scheduling for correctional facility
Handling different weekend situations in Excel
Handling holidays in scheduling
Intake date and Phase Up in scheduling
Monthly haircuts on Saturdays
Using binary digits to specify weekends
Using WORKDAY.INTL for precise scheduling
WORKDAY.INTL function

свернуть