Advanced filter date problem

I am using the advanced filter but I am running into a problem when using a date in the criteria range. The data being filtered contains the hour and minute 1/17/2011 8:00:00 AM, the cell is formatted to display Mon-Jan-17-11. I would like to filter for anything on Monday January 17 2011 irregardless of the time. Is there a way to do this with the advance filter?? How should I be entering this in the criteria range.

Hi pdmkh,

Look at http://www.contextures.com/xladvfilter01.html down the page in a section of:
Excel Advanced Filter Criteria Examples

hope that helps.

I was thinking you would use two dates in the criteria and use the AND reasoning.
If you wanted all dates and times in 1/6/2011 you would filter all >1/5/2011 and < 1/7/2011
See http://www.ozgrid.com/Excel/advanced-filter.htm for the example with ages instead of dates.

with dates in col a starting A2
pick somwhere for critereria say d1:d2
leave d1 blank
in d2 put =trunc(A2)=$E$1
put the date you want to filter on in E1
now advance filter using d1:d2 as criteria

now im puzzled are you saying its easier to use 2 columns? than use that formula approach? i dont believe it! and given that
if you filter > 21/2/2010 and < 23/2/2010 it would not only pass all 22/2/2010 but also would be 21/2/2010 08:00 as any time added would make it meet the criteria > than 21/2/2010

Please have a look at the attached workbooks. They demonstrate how I have used the advanced filter and it appears to work. Adding another date column (targeted start) in "ADVANCED FILTER TEST 1" is not an issue. Howerver I am concerned that, based on your last comments, I may have a problem with the information passing. I have tested the criteria listed in "ADVANCED FILTER TEST 2" several times with different crews and dates and it works.

cant really see where your filters are
but >1/23/2011 would probably omit 1/23/2011 00:00

Hi pdmkh

Find the attached with the correct advanced filter. Note that you need two of the field heads of "Start Target" in the Criteria header line but only one in your data. You are not supposed to ever have the same field names in the headers of the data. I think this was the problem. Also, formatting the dates correctly is important.

Advanced Filters have huge power but aren't the most obvious beasts in Excel.
Hope this helps.

back to what i said
or change your first criteria to >=12/9/2010
i said before any time added to a date will make it >than the actual date >12/08/2010 means anything greater than
12/08/2010 00:00 so 12/08/2010 00:01 will make it through the filter

nothing to do with formatting , the cell value remains the same
but >6 and <7 will work as its not the same as you were trying before >8 <10