In order to sort by days in the week, format the cells to show the day in the week. If you need to sort with the day of your 7 days whatever the date, change them to text by utilizing the TEXT function. Recording of the macro starts right away https://www.customguide.com/google-docs/how-to-create-a-google-doc