If you would like sort by days on the 7 days, format the cells to show the day in the week. In order to sort by the working day of the 7 days whatever the date, convert them to text by utilizing the TEXT function. On Android and iOS, it https://www.customguide.com/excel/if-function-excel