Has last Friday in a cell (A1), work week data in a column, needs to find A1 in columnn B

Aha..now I understand

Try

=REPLACE(B1,1,13,"")*1=$A$1

or simply

=RIGHT(B1,10)*1=$A$1

Copy down