If you want to sort by times of your 7 days, format the cells to show the day with the 7 days. If you want to sort from the day with the week whatever the date, change them to text by utilizing the TEXT function. During this dialog box, you'll https://www.customguide.com/excel/hlookup