Hi Dave
FYI only, in xl2003 if I format real dates with a custom number format of dddd,
I see the days of the week, not the dates.
Another difference between 2003-2007 <g
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dave Peterson" wrote in message ...
I'd insert a new column and use a formula like:
=text(a2,"dddd")
and filter by that.
FYI only, in xl2003 if I format real dates with a custom number format of dddd,
I see the days of the week, not the dates.
Madiya wrote:
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
--
Dave Peterson
__________ 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