Nydia,

The best solution is to insert about five rows above your data. So assuming
rows 1 through 5 are blank, row 6 is column titles and the first date is in
cell G7. Also assume the column title in cell G6 is "Date".

In Cell A1 enter "Date" without the quotes. It must be the same as cell G6.
In Cell B1 enter "Date" without the quotes. It must be the same as cell G6.
In cell C1 enter "Blanks" without the qoutes.
In cell A2 enter "=10/1/2008" without the quotes.
In cell B2 enter "<=10/31/2008" without the quotes.
In cell C3 enter "=isblank(G7)" without the quotes. Once entered it should
return "False" assuming G7 has a date.

Set the data range in Advanced Search to G6:G65000.
Set the criteria range in Advanced Search to A1:C3.

OK, that should do it.

Remember that Advanced Search is not volatile. To get it to update you must
click <Data<Filter<Advanced Filter<OK.

The 1,2,3 in my previous post just represented row numbers and did not need
to be entered.

I hope this gets you going.

Once you get it working you can change the literals in cells A1 and B1 to
formulas to make it easier.

Tom