thank you sooo much for all your help

"Dave Peterson" wrote:

=or() looks for any argument to be true and it'll return true.

So if the date in a1 is in October of 2008 or the cell is empty, then you'll see
a true.

If both of those are not true, then you'll see a false.

Nydia wrote:

Cool, this seem to work. should Blanks=true?

Also, so I can understand, can you explain the formula for me

"Dave Peterson" wrote:

pps.

I sometimes add a helper column and do all my logic in a formula:

=or(text(a1,"yyyymm")="200810",a1="")

And filter to show True/False.



Nydia wrote:

autofilter does not let me use the between 10/01/08 and 10/31/08 and blank.

"Dave Peterson" wrote:

ps. I meant I'd use autofilter, too.

Nydia wrote:

Hello all,

I have an excel spreadsheet that keeps tracks of request. Each month I have
to distribute this. It is a running list, but I only need to send the
requests completed for that month and any pending. So there is a date
column, which is labeled Date completed. If it was completed it will have a
date, if it is not completed and is pending it will be blank.

So, is there a way to filter between dates and blanks?

Example
between 10/01/08 and 10/31/08 and BLANKS

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson