Help with Dates

[Atoosa]

I have two dates that span several years. I want to remove weekends and holidays. I'm using the NETWORKDAYS function. I have a list of recognized holidays for the current year. Will I have to format or remove the "Year" in the holiday dates to have the formula account for the years in between dates? Hope this makes sense? Here is an example:

1/5/2007 1/10/2018 Holidays
1/1/2018
2/1/2018


Thanks for any assistance.

 

[Ron Coderre]

You'll need to list ALL of the holidays in the referenced date range.

 

[Atoosa]

You'll need to list ALL of the holidays in the referenced date range.

Thanks for your prompt response. So I would have to list all holidays for 2017 and 2018,just to be clear. Some of the dates span several years.

 

[Ron Coderre]

Yes, there's no reliable way to make Excel undestand how you want the holiday dates treated. For instance, the U.S. thanksgiving holiday is the 4th Thursday of November. The actual day of the month changes. Consequently, every holiday date needs to be listed.