Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Holidays Between Two Dates – 2369

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.