Get Weekday Date
This formula will get the date of a weekday in the same week as the date in A1
A1= Date, B1 = Weekday (Sunday = 1. Adjust this number to work with other weekdays such as Monday = 2, Tuesday = 3 etc)
All Rights Reserved.