****** name="Title" content=""> ****** name="Keywords" content=""> ****** http-equiv="Content-Type" content="text/html; charset=utf-8"> ****** name="ProgId" content="Word.Document"> ****** name="Generator" content="Microsoft Word 11"> ****** name="Originator" content="Microsoft Word 11"> <link rel="File-List" href="file://localhost/Users/sinclair/Library/Caches/TemporaryItems/msoclip1/01/clip_filelist.xml"> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Template>Normal</o:Template> <o:Revision>0</o:Revision> <o:TotalTime>0</o:TotalTime> <o:Pages>1</o:Pages> <o:Words>132</o:Words> <o:Characters>758</o:Characters> <o:Company>BesTel Solutions, Inc.</o:Company> <o:Lines>6</o:Lines> <o:Paragraphs>1</o:Paragraphs> <o:CharactersWithSpaces>930</o:CharactersWithSpaces> <o:Version>11.1282</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:Zoom>0</w:Zoom> <w:DoNotShowRevisions/> <w:DoNotPrintRevisions/> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery> <w:UseMarginsForDrawingGridOrigin/> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:"Times New Roman"; panose-1:0 2 2 6 3 5 4 5 2 3; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:50331648 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman";} table.MsoNormalTable {mso-style-parent:""; font-size:10.0pt; font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--StartFragment--> I need to find all rows in one worksheet that fall within a specified date range. I have two worksheets, one contains the data and the other is used to display the selected data. I need a formula to find all the names, with a start date and end date that falls within a selected month.<o
></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Data worksheet<o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
A B C D<o></o>
1 Name Notes Start Date End Date<o></o>
2 jake 5/18/2009 6/10/2009<o></o>
3 Jim 9/15/2009 10/13/2009<o></o>
4 Joe 10/1/2009 11/6/2009<o></o>
5 Jim 10/28/2009 11/6/2009<o></o>
6 Sam 11/15/2009 11/18/2009<o></o>
7<o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Display worksheet<o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
If the month is October, display the following rows. Jim should appear twice, since he has more than 1 entry in the month.<o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
A B C D<o></o>
1 Name Notes Start Date End Date<o></o>
2 Jim 9/15/2009 10/13/2009<o></o>
4 Joe 10/1/2009 11/6/2009<o></o>
5 Jim 10/28/2009 11/6/2009<o></o>
6 <o></o>
7<o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Can anyone help me with this? Thanks in advance.<o></o>
<!--EndFragment-->
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Data worksheet<o
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>A B C D<o
></o>1 Name Notes Start Date End Date<o
></o>2 jake 5/18/2009 6/10/2009<o
></o>3 Jim 9/15/2009 10/13/2009<o
></o>4 Joe 10/1/2009 11/6/2009<o
></o>5 Jim 10/28/2009 11/6/2009<o
></o>6 Sam 11/15/2009 11/18/2009<o
></o>7<o
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Display worksheet<o
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>If the month is October, display the following rows. Jim should appear twice, since he has more than 1 entry in the month.<o
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>A B C D<o
></o>1 Name Notes Start Date End Date<o
></o>2 Jim 9/15/2009 10/13/2009<o
></o>4 Joe 10/1/2009 11/6/2009<o
></o>5 Jim 10/28/2009 11/6/2009<o
></o>6 <o
></o>7<o
></o><!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Can anyone help me with this? Thanks in advance.<o
></o><!--EndFragment-->
