In order to sort by days of your 7 days, format the cells to show the working day in the 7 days. In order to sort via the working day of the week whatever the date, convert them to text by using the TEXT function. , Excel authorities Mr. Excel https://www.customguide.com/excel/how-to-move-cells-in-excel