first unique name fir each date

[watfordo]

I have a records with names and dates.
Each name may receive 1 referral bonus point per date.
For each date, I would like to indicate (maybe highlight) and eventually tally 1 instance of a name, but not duplicate names on a given date.
In the example below, the records with asterisks would be qualifying.

11/3/2015 SMITH, JOE*
11/3/2015 SMITH, JOE
11/3/2015 SMITH, JOE
11/30/2015 CLINTON, BILL*
11/2/2015 DOE, JOHN*
11/2/2015 DOE, JOHN
11/11/2015 RAY, SUGAR*
11/11/2015 RAY, SUGAR
11/11/2015 RAY, SUGAR

Bonus for an running report of name, qualifying dates, and number of hits per time period (probably month)

Thanks for an help

[FlameRetired]

The formula shown below is what I used for conditional formatting formula.

Row\Col	A	B	C	D
1	11/3/2015	SMITH,	JOE	=COUNTIFS($A$1:$A1,$A1,$B$1:$B1,$B1,$C$1:$C1,$C1)=1
2	11/3/2015	SMITH,	JOE
3	11/3/2015	SMITH,	JOE
4	11/30/2015	CLINTON,	BILL
5	11/2/2015	DOE,	JOHN
6	11/2/2015	DOE,	JOHN
7	11/11/2015	RAY,	SUGAR
8	11/11/2015	RAY,	SUGAR
9	11/11/2015	RAY,	SUGAR

[Beamernsw]

Hi, extending from FlameRetired's great formula, I've created a "Report" sheet that, by using a few helper columns, might be what you were looking for.

Or at least close enough to give you some ideas to further your own sheet.
Hope it helps.

Helper columns (A,B,C) can be hidden from view if you wish, but the formulas have only been copied down about 250 lines.

[watfordo]

Awesome!
Works great!

I have one other issue.
The date field is formatted as a short date, but the underlying data is date + time
Example
11/3/15 3:30 PM

So identical dates don't show as duplicates because the time (hours and minutes) is different
Example
11/3/15 3:30 PM
11/3/15 3:36 PM

How can I truncate the date in the formula so that the hours and minutes aren't considered a unique date value?

[Beamernsw]

If date is in A1, try =INT(A1)