Counting Holidays

[John]

How can I count the number of holidays between 2 dates?
Do I need to create a list? Can I import a list

 

[Jim]

Because there is such a wide variety of holidays, you will have to create
your list of holidays. Once you have created the list (by date, not name),
you can use:
=COUNTIF(C2:C1800,">=7/10/03")-COUNTIF(C1:C18,">12/10/03")
to find the number of holidays in your list between July10, 2003 and
December 12, 2003.

 

[2rrs]

try this:

=NETWORKDAYS(start_date,end_date)-NETWORKDAYS(start_date,end_date,Holidays)

You will need to create a list of Holidays; this list can be given a
named range "Holidays"