|If it's not working for you, then you'll need to give us some more specifics.|
I used your formula in A1:
And my formula in A2:
I put 1's in B5:O5 and both formulas returned -0.104166667
I then tried a few other number combinations and each time both formulas returned the matching results, so we know that they are equivalent.
I then put the word Holiday in B5 and your formula returned #VALUE while mine returned 0.90625.
I then tried Holiday in each column B - O and my formula kept returning numbers while yours always returned #VALUE.
I even tried Holiday in multiple cells, all the way up to having Holiday in every cell. My formula never returned an error, yours did whenever there was text anywhere in B5:O5.
Posting Tip: Before posting Data or VBA Code, read this How-To.