NETWORKDAYS Function with FILTER for Conditional Holidays Ranges

In this video, we use the NETWORKDAYS function with the FILTER function for conditional holiday ranges. The NETWORKDAYS function returns the number of working days difference between two dates. And it includes the option to add custom non-working days. In this video, the non-working days depends on which member of staff is doing a task. So we need to return the holiday ranges for that specific person. Fortunately, the excellent FILTER function provides the ability to filter the list and return the range that we want. The video then has a bonus example with the XLOOKUP function returning the range dynamically. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1