Count only unique dates in an entire range even if some cells in range are blank

[PitchNinja]

So I'm looking to make a tool for my supervisor to use when he needs to count amount of days worked for an employee. I am currently using the following formulas in the existing sheet I gave him before:

In cell S8:
=INT(D8) The dates they work are in column D.
For this particular employee, their dates extend all the way down to S80.

In cell S81:

Please Login or Register  to view this content.

The reason why we have the formula counting unique dates is because there is a possibility the same date will appear twice due to them receiving different pay rates from differentials or premiums. This formula works nice, but the problem is every employee is different in the amount of days they have worked, so we constantly have to change the range end. I moved the =SUMPRODUCT(1/COUNTIF(S8:S80,S8:S80)) formula that was in S81 to column T in hopes that we could just use the entire S column in the range instead of a specified number so that it would look like =SUMPRODUCT(1/COUNTIF(S:S,S:S)). Naturally it gave a #div/0 error. So I am wondering if there might be an alternative that we can use or how the formula might be adjusted so that going forward, he can just paste any new employee's data over the previous employee he had already done.

[wk9128]

Try S81 cell formula

[PitchNinja]

Try S81 cell formula

Cool thanks for that. I put the formula in column T and was able to even just have it as:

Please Login or Register  to view this content.

So now it will only count unique dates and won't count blank cells. Thanks for the help!

[wk9128]

You're Welcome. Thank You for the feedback