I found this fun challenge on the Mr. Excel forums.
You can count unique items in a list with an array formula described on Chip’s site. I use a variant of it below.
The problem is that if you have a list of dates and times and you only want a count of the unique days. To disregard the times, try the below formula.