If you would like sort by times from the week, format the cells to show the day of your 7 days. If you want to sort via the working day of the week whatever the day, change them to text by utilizing the TEXT function. This can be helpful for https://www.customguide.com/excel/how-to-enable-macros-in-excel