If you need to sort by days from the 7 days, format the cells to show the day with the week. If you want to sort with the day of the 7 days regardless of the day, transform them to text by using the TEXT function. You may commonly modify https://www.customguide.com/windows-10/quick-assist