I have a speadsheet like following:

Cust Name, Date
My Name1 Monday
My Name2 Sunday
My Name3 Friday

I wanted to use Advance filter out which date equals Sunday.

How I should write my criteria?

Thanks millions in advance,

If it is the Word Sunday and Excel is reading it as text, use this as your
Criteria:
Date (for the Heading)
<Sunday (for the criteria

If the date is being read as a date, you can use this as your criteria:
=WEEKDAY(B6,1)1
This example assumes the first date is in B6. When using a formula, there is
no Heading - you simply select the blank cell above the formula.
See http://www.contextures.com/xladvfilter01.html.

--
tj


"Souris" wrote:

I have a speadsheet like following:

Cust Name, Date
My Name1 Monday
My Name2 Sunday
My Name3 Friday

I wanted to use Advance filter out which date equals Sunday.

How I should write my criteria?

Thanks millions in advance,

Select the area that you want to filter (including the headers).
Data - Filter - Autofilter
On the Date column click on the down arrow and select SUNDAY.

"Souris" wrote in message
...
I have a speadsheet like following:

Cust Name, Date
My Name1 Monday
My Name2 Sunday
My Name3 Friday

I wanted to use Advance filter out which date equals Sunday.

How I should write my criteria?

Thanks millions in advance,