Find records that meet this criteria

[fgwiii]

Hello,

I need to create a query that will search about 10 individual date fields
to see if any of the dates are: greater than 30 days prior to, or 1 day
after the
<pdate>.

The data is laid out like this:
person dt 1 dt2 dt3 dt4 dt5
dt6 pdate
rec1 7/6/09 5/6/09 4/12/09 5/5/09 9/12/09 5/15/08
6/6/09

Thank you,

 

[Dave Peterson]

Maybe you can add another column and use a couple of =countif()'s.

=countif(b2:g2,">="&h2-30) + countif(b2:g2,">"&h2+1)

I'm not sure about what happens at the 30 day prior mark.
You may want ">" or ">=".

Or even "<="&30 if greater than 30 means before 30 day prior.

(I always have trouble deciphering those date requirements!)

Then drag this formula down your data and apply autofilter to show the not equal
to 0's.

 

[T. Valko]

I always have trouble deciphering those date requirements!

Me too!