Check out Data Filter AutoFilter and set the "Custom" selections to be
"greater than or equal to" and "less than or equal to" your desired
range............to revert to normal, just do Data Filter AutoFilter
again, it's a toggle.......
Vaya con Dios,
Chuck, CABGx3



"David Eastham" wrote in message
...
I have a table with 6 columns and about 100 rows. In the table I have
various dates for when I need to look at test results after 1 week, 1
month,
3 months, 6 months, 12 months and two years, starting from when I started
the test. Is there a way of finding a date between a range of days eg if
I
input next weeks dates Monday to Friday it will find all the dates in the
table that fall within this range?
Thanks