I have a option in my Table add-in for days
Create a Table of you range and use the Date button on the Table tools Ribbon

http://www.rondebruin.nl/table.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Madiya" wrote in message ...
Using Excel 2007.
I have 6000+ rows of data with date.
When I formate date with DDDD, I can see sunday, monday etc but if I
click on autofilter, all dates are listed instead of day. I want to
filter on Monday, or tuesday or sunday....but excel does not like it.
How to do that. Pl help me.


Regards,
madiya

__________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________

The message was checked by ESET Smart Security.

http://www.eset.com