FIND
 

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

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

Hi David,
You would want to use Conditional formatting, for that
you can have up to 3 conditions being checked per cell.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Example of a formula -- the address is relative (or same) to the active cell
=AND(C1=DATE(2005,6,5),C1<DATE(2005,6,5)+7)

You can make the date reference a specific cell i.e. $A$1

Make sure that row 1 is showing
Select columns C:G which will mean C1 is the active cell
Format, Conditional Formatting
Formula is: (on the dropdown), enter the formula above
choose a pattern color from the format button

If you want to add additional colors use the ADD button in
C.F. the first of the 1 to 3 conditions that matches will be used.

To Eliminate all C.F.
Ctrl+A (in Excel 2003 use Ctrl+Shift+Space)
Format, Condition Formatting, delete button, check all 3 format boxes, ok




--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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