If you wish to sort by days of your 7 days, format the cells to show the day in the week. If you need to sort by the day in the week regardless of the date, convert them to text by using the TEXT function. I found a new macro https://www.customguide.com/excel/excel-sum-formula