Find date of max occurrence of name from table

[eggman9]

I am looking for a formula to calculate the date that a sales person makes the most sales. I have a huge table that looks similar to this:

Sale Date	Name
1/5/22	Sam
1/5/22	Frank
1/6/22	Bob
1/7/22	Frank
1/7/22	Frank
1/7/22	Frank

I want to enter the name I am interested in finding, and it would output the date that the person sold the most. In this example, if I were interested in Frank, it would output 1/7/22 because that is the date that his name appears the most.

Please let me know if this requires further clarification, thanks!

 

[eggman9]

They were in datetime format, changing it to date fixed it! Thank you both!

 

[Fluff]

Glad we could help & thanks for the feedback.