Hi,

Assume that your data is in range B4:H10 (including the header row). In
A14, type the date. In cell B14, enter =COUNTIF(C5:H5,$A$14)0. In cell
B13, type condition1 and in B17, type Acct Nu (the same heading as in the
source range). Now go to DataFilterAdvanced FilterCopy to another
location. In the list range, select A4:H10. In the criteria range, select
B13:B14. In the copy to box, select B17. Click on OK.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"crazidazi3" wrote in message
...
I can't find my org post, so reposting..sorry.

I have a worksheet that has multiple columns, with multiple dates..

Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5
1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09
2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09
3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09
5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09

I need to filter for all acct #s with a follow up date of 10/24/09 (or
whatever date I need). I have tried all versions of advanced filter, but
it
does not allow you to search by multiople date across columns. Please
help!
--
crazidazi3