In order to sort by days with the week, format the cells to show the working day in the week. If you wish to sort because of the working day on the week regardless of the date, convert them to text by utilizing the TEXT function. “Protection Danger – Microsoft https://www.customguide.com/excel/find-and-replace-in-excel