If you need to sort by days on the 7 days, format the cells to show the day in the 7 days. If you wish to sort from the working day from the week regardless of the date, convert them to text by utilizing the TEXT function. To change the https://www.customguide.com/excel/how-to-change-date-format-in-excel