advance filter excluding record

S

Souris

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,
 
T

tjtjjtjt

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.
 
B

Barb Reinhardt

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.
 
Top