On Sep 8, 2:26*pm, Javed wrote:
Dear Madiya,

I f you can change the number format of the column then easily you can
do what you want.

Step 1:From Excel Options--Advanced--Uncheck the Group Dates Auto
Filter menu

Step 2:Change the Number format .Select Format cells from right click--

In the number tab go to Custom and type dddd in edit box.

This will show all the date in Weekday (ie Sunday,Monday).then you can
filter.

Both solutions worked.
Thanks a ton to both of you.

Regards,
Madiya