If you wish to sort by days of your week, format the cells to show the day from the 7 days. If you would like sort because of the day with the week regardless of the day, change them to text by utilizing the TEXT function. , Excel authorities Mr. https://www.customguide.com/excel/get-help-with-excel