Number of Pay Periods in Range with SumProduct

For ex. Morticia Addams with coverage from 1/1 - 1/2, there should be one pay period within which those dates fall (the pay period running 12/31/14 - 1/3/15. So it should return 1, not 0.

Please disregard I found the answers to these.


Should holidays and weekends be considered? 1/1/15 is a holiday and 1/3/15 is a Saturday.

Also in the above you indicate pay period running 12/31/14 - 1/3/15. I don't know if it will matter or not but there is

a pay period 12/21/14 - 1/3/15 but not 12/31/14 - 1/3/15.

I assume one of these is a typo. Which one? If the period is supposed to be from 12/21 there is another holiday if it matters.

I still cannot get all of the counts to agree with your expected numbers. I keep coming up with new disagreements, though. LOL