If you wish to sort by times from the 7 days, format the cells to show the day of your week. If you'd like to sort from the working day from the week whatever the date, transform them to text by utilizing the TEXT function. I found a fresh macro https://www.customguide.com/excel/goal-seek-excel