Great examples. What about if workday includes absence from scheduled vacation on a Tuesday of work week of Monday through Thursday or someone called out sick like a on a Thursday? Also this includes with and without holiday
Hi, @E Park. Nice question! There are 2 ways to approach this: (1) You can include the dates of the leaves as part of your holiday list so that you can still count the number of actual of workdays in from your start date to end date. This will exclude the applied leaves/absences in the count. (2) MS Excel has hidden a "argument" for weekends. There are unusual workweeks for some people, for example, Mondays to Thursdays. So there should be 3 rest days in a week. Since there are no "assigned numbers"/arguments for these (e.g., "5" for Wed-Thur), we can make use of 0s and 1s. 0 = Work day (note that workweek starts on a Monday) 1 = Rest day So, in our example in the video, we can use the function WORKDAY.INTL this way: =WORKDAY.INTL(M19,60,"0000111",N19:N36) This formula indicates that a work week starts on a Monday and ends on Thursday. I hope I was able to answer your question :)
Great examples. What about if workday includes absence from scheduled vacation on a Tuesday of work week of Monday through Thursday or someone called out sick like a on a Thursday? Also this includes with and without holiday
Hi, @E Park. Nice question!
There are 2 ways to approach this:
(1) You can include the dates of the leaves as part of your holiday list so that you can still count the number of actual of workdays in from your start date to end date. This will exclude the applied leaves/absences in the count.
(2) MS Excel has hidden a "argument" for weekends. There are unusual workweeks for some people, for example, Mondays to Thursdays. So there should be 3 rest days in a week. Since there are no "assigned numbers"/arguments for these (e.g., "5" for Wed-Thur), we can make use of 0s and 1s.
0 = Work day (note that workweek starts on a Monday)
1 = Rest day
So, in our example in the video, we can use the function WORKDAY.INTL this way:
=WORKDAY.INTL(M19,60,"0000111",N19:N36)
This formula indicates that a work week starts on a Monday and ends on Thursday.
I hope I was able to answer your question :)