You can use the WEEKDAY function to find the weekday number, where Sunday is 1 and Saturday is 7. For example, use =WEEKDAY(A2, 2) to start the week on Monday.