I am trying to exclude ALL Sunday's and ALL Holidays from my formula to only show days between Monday & Saturday so I can list out all the work days in my excel spreadsheet. I found the following formula online that says it will exclude both Sunday's and Holidays but it's only excluding Sunday's. The holidays are still showing. What is wrong with this formula and how can I fix this to work correctly? This is an array formula too. I have a named range called Holidays to show all the holidays we have for 2018.