If you want to sort by days of the week, format the cells to show the working day from the 7 days. In order to sort by the day of your week regardless of the day, transform them to text by using the TEXT function. You are able to typically https://www.customguide.com/excel/pivot-table-excel