Finding common dates in two columns

[HaroldDavis]

I have a column with visit dates that will change with each user. I have made another column with all of the holidays for the year. I would like to be able to determine if there are common dates in the columns. If the dates could be identified that would awesome but even if I only get an indication that somewhere in the columns there is a common date it would be helpful.

Thanks all.

 

[John Davis]

I have a column with visit dates that will change with each user. I have made another column with all of the holidays for the year. I would like to be able to determine if there are common dates in the columns. If the dates could be identified that would awesome but even if I only get an indication that somewhere in the columns there is a common date it would be helpful.

Thanks all.

Perhaps VLOOKUP in a separate column - Sample below uses Column B as holidays, and Column A as visit dates.

=IF(ISNA(VLOOKUP(A1,$B$1:$B$6,1,FALSE)),"","Common Date")

 

[HaroldDavis]

Thank you. That works.

 

[John Davis]

Thank you. That works.

You're welcome. Thanks for the feedback.