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

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" <(E-Mail Removed)> wrote in message news:1d3df2cd-3748-4fe2-8c62-(E-Mail Removed)...
> 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

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

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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

xl2007 has a lot of "enhancements" (not just differences!).

<vbg>

Ron de Bruin wrote:
>
> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > 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

--

Dave Peterson

Hi Ron

I had not realised that you had updated the add-in to include this.
I have just updated my download.
It is very nice - thank you.

--
Regards
Roger Govier

"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:1d3df2cd-3748-4fe2-8c62-(E-Mail Removed)...
>> 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:1d3df2cd-3748-4fe2-8c62-(E-Mail Removed)...
> 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

I hope you like it Roger

--

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




"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message news:58C6BE98-ED04-40E9-9460-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:1d3df2cd-3748-4fe2-8c62-(E-Mail Removed)...
>> 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

On Mar 28, 10:29*pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> I hope you like it Roger
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
>
>
> "Roger Govier" <roger@technology4unospamdotcodotuk> wrote in messagenews:58C6BE98-ED04-40E9-9460-(E-Mail Removed)...
> > 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" <madiya...@yahoo.co.uk> wrote in message
> >news:1d3df2cd-3748-4fe2-8c62-(E-Mail Removed)...
> >> 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- Hide quoted text -
>
> - Show quoted text -

Hi all,
Thanks for all the help.
Its nice to get a solution on monday morning and that too by so many
people.
and both the solutions works for xl2003 and xl2007.
Thanks Ron, I have downloaded your addin and exploring the same.

Regards,
Madiya