Get Weekday Date

This formula will get the date of a weekday in the same week as the date in A1

=A1-(WEEKDAY(A1)-B1)

A1= Date, B1 = Weekday (Sunday = 1. Adjust this number to work with other weekdays such as Monday = 2, Tuesday = 3 etc)