Hi Gasper. Using the string value for weekends in the .INTL functions is a great trick. However, I think you presented it in reverse. If you look at the Microsoft documentation, 1 = a non-working day or a weekend day and 0 = a workday. The first string value represents Monday, so, to define a workweek of MWF and weekends of TTSS, the string value would be 0101011 vs. the 1010100 you indicated in the video. The argument defines the days not worked (i.e. weekend days), so the 1 = TRUE for weekend day not for working day. Debra Dalgleish just posted a great video on how to use WORKDAY.INTL to coax the nth day of the month. So for example, =WORKDAY.INTL(DATE(2022,1,0),2,"0111111") would return the date of the 2nd Monday in the month of January 2022. Pretty neat trick! Thanks again for all your videos and resources.. always learning and having fun too :)) Thumbs up!!
OMG. Thanks a million, Wayne. I've must have been hit by lightning when I was recording :). And I've been using the functions for years... And I even explain how ones and zeros are true or false, whether it is a weekend. Well. Not my finest hour. But I thank you for letting me know, and now I need to figure out how to fix it :)
@@ExcelOlympics Hi Gasper. Glad to help. I've reversed it enough times myself. So, I tend to check the documentation again if I have not used it recently. After this, probably I'll always remember it haha :)) Cheers!!