If you'd like to sort by days from the 7 days, format the cells to show the day with the 7 days. If you'd like to sort because of the working day of the 7 days regardless of the date, transform them to text by using the TEXT function. WordCounter.net https://www.customguide.com/excel/how-to-unhide-columns-in-excel