sorting

[slimjen]

Hi all,
I have data that need to be sorted in a worksheet. The problem is, the data are dates for the day of the week. For example, the column name is value date. In the cells, it list the day of the week in date format. 4/1/07, 4/2/07 and so on. I change the format to dddd which now gives me Monday, Tuesday and so on. I want all the Mondays in the month, all the Tuesday in the month and so on together because another column contains a number of transactions to be calculated. But, I can't sort where they will be together unless I manually cut and paste because they are still dates rather them text.
I hope I didn't confuse you. Here's an excerpt of my worksheet.

Please Login or Register  to view this content.

I hope someone can help.thanks

[jjjjj55555]

If you don't mind adding an extra column you could use the weekday function which assigns a number between 1 & 7 to each day of the week. Then sort by that column instead of your dates column.