Apache OpenOffice Community Forum

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.

You can add a third that uses the WEEKDAY() function like this See the help section for the meaning of the second parameter. You can then sort on the third column to get what you want.