If you want to sort by days with the 7 days, format the cells to show the working day from the week. If you'd like to sort via the working day of the 7 days whatever the day, change them to text by utilizing the TEXT function. To change the https://www.customguide.com/excel/vlookup