Count unique values on a specific date

Thanks - that is an awesome formula. It looks like it works perfectly. I need to check it out on my entire data range (appr. 9000 rows) when I get to work on Monday.