Filtering dates in two different columns

  • Thread starter Thread starter michelle
  • Start date Start date
M

michelle

I want to be able to show within a range of data only data
for a certain period ie week (same criteria for each
selection) but apply to two different columns.

By filtering I can do each separately but I want on same
report. Have tried advance filtering but got stuck.

Unsure if this is clear but the fields are "Land Set
Date" "Prop Set Date" as data contains information for
both types of settlements and I need to show for the
following week what settlements in total are.
 
Hi Michelle

Not sure if I understand your question clearly. I have assumed that
the 2 columns containing dates are Cols A & D.
I have also assumed that the date is in the form of a weeknumber
e.g.48

This formula goes in any blank column

=IF(A1=48,1,IF(D1=48,1,0))

Copy down as far as necessary.

If you then filter on the new column using 1 you will only see rows
where week 48 is in col A or D

If there are dates rather than week numbers in your columns you will
need to change the if statements to cover start and finish dates

David P
 
Back
Top