Ok, so here is an example of my worksheet.
Untitled.png

I am currently using the following formula to count the unique number of dates in column A (displayed in E5).
=SUMPRODUCT((A2:A5<>"")/COUNTIF(A2:A5,A2:A5&""))

I would like to make a change so the formula in E5 will only count days that have text (or are not blank) in column C of same row (so it's not counting days not worked yet).
I can't think of a good way to do this. Any ideas?

Thanks!