In order to sort by times of your 7 days, format the cells to show the working day on the 7 days. If you wish to sort with the day in the week whatever the date, convert them to text by using the TEXT function. The following table lists the https://www.customguide.com/google-sheets/how-to-lock-cells-in-google-sheets