If you would like sort by days on the week, format the cells to show the working day from the 7 days. If you'd like to sort through the working day in the week whatever the day, change them to text by using the TEXT function. Recording of your macro https://www.customguide.com/excel/excel-macros