If you wish to sort by days of the week, format the cells to show the day on the 7 days. If you wish to sort because of the working day of your week regardless of the date, convert them to text by utilizing the TEXT function. , Excel authorities https://www.customguide.com/excel/flash-fill-excel