Count of unique dates in a column

Occasional Contributor

Good afternoon!


See attached. If you manually count the unique DATES in column A associated with the name "John Doe" in column B, you count 17 unique dates.


I'm looking for a formula that does that in a worksheet with 28,000 rows and 400 different names. Keep in mind, I don't want the formula to pay any attention to the time that is built in to the date format. Just the date itself.


Can this be done?

2 Replies
best response confirmed by Danger_SF (Occasional Contributor)




Is this what you want to do? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.

Nice job! That worked. Thank you!