After episode 2363, a pair of great questions and a tip.
Tip 1: When specifying the Holiday Range in Excel, make the range into a table and then name the range. That way, when you add new holidays at the bottom, the named range will automatically expand.
Question 1: How many holidays fall between two dates?
Question 2: What is the list of holidays between two dates?
This video includes details on NETWORKDAYS.INTL and FILTER functions.
You will also see how I take two sub-formulas that were in different cells and combine them into a single formula by scooping the characters out of each formula.
Table of Contents
(0:00) Welcome
(0:17) Binary option for WEEKEND argument in Excel
(1:15) Table, Named Range for Holidays
(1:37) Named range extends after adding holidays
(1:56) How many days between dates
(2:06) Days excluding holidays
(2:54) Number of Holidays
(3:09) One formula
(3:45) List of holidays in Excel
(5:31) Recap