If you wish to sort by times from the 7 days, format the cells to show the working day on the 7 days. If you'd like to sort from the working day from the week whatever the date, change them to text by utilizing the TEXT function. Observe: If you https://www.customguide.com/excel/hlookup