If you want to sort by days in the 7 days, format the cells to show the day on the 7 days. If you want to sort with the working day in the 7 days regardless of the day, convert them to text by utilizing the TEXT function. The Format https://www.customguide.com/excel/how-to-add-a-column-to-a-table-in-excel