In order to sort by days with the week, format the cells to show the day of your week. If you'd like to sort via the working day on the 7 days whatever the date, transform them to text by using the TEXT function. Accessibility Heart Communities help you request https://www.customguide.com/excel/excel-left-function