Filtering on a Day of the Week

[misnole]

Hello,
Was hoping someone might can help me with this issue. I have an SSRS report that I am exporting to Excel. What I'd like to be able to do is then sort by a day of the week, for example: Monday.

So if the date range of the report was for 3 months, I'd like to be able to create a filter or a macro that would only show me the data from the Mondays that occurred in this 3 month period.

When I look at the format of the cell (or column) for the date, it is a Custom [$-10409]dddd,mmmm dd, yyyy.

If that helps.

Is this possible?

[oeldere]

=text(weekday(a1),"dddd") and drag down.