Hi

Column A i have a list of dates
Column B i have a list of names

Range C1 i have a cell to enter a name

Enter a name in C1
and C2 brings back a value that counts unique dates in Column A, where column B equals C1

where column A is between the first day of the current year and todays date

Thanks in advance