I hope you like it Roger
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ...
Hi
I have just tried Ron's add-in and it works perfectly for this (and many
other date options as well).
If, for any reason, you are not allowed to to use add-ins, then you could
insert a new column adjacent to your date column
with the formula =WEEKDAY(A2) and copied down.
Filter on 5 for Thursday etc.
--
Regards
Roger Govier
"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