Grouping weekdays in a column sort

[philip36]

I am trying to sort a two column sheet by grouping days of the week. Column A is dates and Column B contains prices. I would like to group first all prices for Mondays, followed by Tuesdays, etc. The ascending /descending sort feature only will sort by date. It will not allow me to group or alphabetize the words in the Weekdays of my date formatting.

[FJCC]

You can add a third that uses the WEEKDAY() function like this

Code: Select all

=WEEKDAY(A2;1)

See the help section for the meaning of the second parameter. You can then sort on the third column to get what you want.