If you wish to sort by days on the 7 days, format the cells to show the working day of your week. If you would like sort by the working day on the 7 days regardless of the date, transform them to text by using the TEXT function. “Safety Threat https://www.customguide.com/excel/autofit-excel