I need a formula that calculates business days, but the NETWORKDAYS function
is not adequate. I need the formula to return the number of days between two
dates, excluding a range of holidays. Since my store is open seven days a
week, the NETWORKDAYS function will not suffice. When I used Quattro Pro in
the past, it had a BDAY function, and it accepted parameters to indicate if
weedends were to be included or not. Is there a comparable function in Excel?

I am trying to calculate the number of days the store is open every week. I
thought of using NETWORKDAYS and simply adding 2 (Saturday and Sunday).
However, when holidays occur on a weekend, my formula returns the incorrect
number of days.