unLTD - 12:06 pm on May 13, 2009 (gmt 0)

Here is a simple solution:

1. Create your desired online report using adsense report painting tools

2. Hit CSV export link in your displayed report and either directly open it into Excel or save on local disk as SDF file and then open it into Excel (or your choice of spreadsheet app)

3 In your spreadsheet app (Excel in this eg.) select the entire first column listing data field and change the type of date format to includes day of the week along with full date. This step is actually not required but nonetheless would help you.

4. Now INSERT a column to the left of the column listing date field.

5. Enter following formula into A2 cell of newly inserted first column and copy it across the newly inserted column.
=TEXT(WEEKDAY(B2), "dddd")

This formula would now automatically insert 'day of the week' string into the first cell for corresponding date in second column for whole column.

You can now sort your data using DATA->Sort option on first column and choose data for ANY day of the week across your date time scale.

Hope this helps