Extract to 2nd sheet only flights valid during a 7 day period?

[ctfloydscry]

Excel novice(at best)

Timetable data.csv file

Example/excerpt:

Wish to extract to 2nd sheet only flights valid for 7 day period beginning Jan/14 ending Jan/20 from following....

Jan/1-Jan/13,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ
Jan/16-Feb/28,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ
Jan/7-Jan/14,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ
Jan/15-Jan/21,ABR,6:50AM,MSP,8:12AM,17,7365,CRJ
Jan/28-Feb/28,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ
Jan/1-Jan/2,ABR,1:08PM,MSP,2:30PM,12,7363,CRJ
Jan/3-Feb/28,ABR,1:09PM,MSP,2:30PM,1234567,7363,CRJ
Feb/2-Feb/28,ACC,10:00AM,JFK,4:44PM,156,0220,76W
Jan/1-Jan/30,ACC,10:00AM,JFK,4:50PM,1256,0220,76W

Output to second sheet...

Jan/16-Feb/28,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ
Jan/7-Jan/14,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ
Jan/15-Jan/21,ABR,6:50AM,MSP,8:12AM,17,7365,CRJ
Jan/3-Feb/28,ABR,1:09PM,MSP,2:30PM,1234567,7363,CRJ
Jan/1-Jan/30,ACC,10:00AM,JFK,4:50PM,1256,0220,76W

Possible?

Thank you...

 

[admiral100]

Hi,

To make it easier I added 2 helper columns :

C2 =DATE(2018,MONTH(LEFT(A2,FIND("-",A2)-1)),DAY(MID(A2,FIND("/",A2)+1,(FIND("-",A2)-1)-(FIND("/",A2)))))
D2 =DATE(2018,MONTH(MID(A2,FIND("-",A2)+1,(FIND(",",A2)-1)-(FIND("-",A2)))),DAY(MID(MID(A2,FIND("-",A2)+1,(FIND(",",A2)-1)-(FIND("-",A2))),5,2)))

G2 & H2 your date criteria

Ctrl+Shift+Enter NOT just Enter
A17 =IFERROR(INDEX($A$2:$A$10,SMALL(IF($H$2>=$C$2:$C$10,IF($G$2<=$D$2:$D$10,ROW($A$1:$A$9))),ROW(A1))),"")

	A	B	C	D	E	F	G	H
1	Flights		Extract Start	Extract End		Criteria	Start	End
2	Jan/1-Jan/13,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ		01/01/18	13/01/18			14/01/18	20/01/18
3	Jan/16-Feb/28,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ		16/01/18	28/02/18
4	Jan/7-Jan/14,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ		07/01/18	14/01/18
5	Jan/15-Jan/21,ABR,6:50AM,MSP,8:12AM,17,7365,CRJ		15/01/18	21/01/18
6	Jan/28-Feb/28,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ		28/01/18	28/02/18
7	Jan/1-Jan/2,ABR,1:08PM,MSP,2:30PM,12,7363,CRJ		01/01/18	02/01/18
8	Jan/3-Feb/28,ABR,1:09PM,MSP,2:30PM,1234567,7363,CRJ		03/01/18	28/02/18
9	Feb/2-Feb/28,ACC,10:00AM,JFK,4:44PM,156,0220,76W		02/02/18	28/02/18
10	Jan/1-Jan/30,ACC,10:00AM,JFK,4:50PM,1256,0220,76W		01/01/18	30/01/18
11
12
13
14
15
16
17	Jan/16-Feb/28,ABR,5:00AM,MSP,6:20AM,123456,7365,CRJ
18	Jan/7-Jan/14,ABR,6:50AM,MSP,8:12AM,7,7365,CRJ
19	Jan/15-Jan/21,ABR,6:50AM,MSP,8:12AM,17,7365,CRJ
20	Jan/3-Feb/28,ABR,1:09PM,MSP,2:30PM,1234567,7363,CRJ
21	Jan/1-Jan/30,ACC,10:00AM,JFK,4:50PM,1256,0220,76W

<colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[ctfloydscry]

Thank you for the reply.

The only version of Excel I have is from Office 2000 on an older laptop, one that I haven't used in quite some time. Even then I only used Excel for just very basic editing on above type data, and as such, I'm not too familiar on the use of formulas and other functions, so you'll have to pardon my ignorance here, but, (a) will these work with Excel 2000? If so, is there an idiots guide as to how these are applied? I've been watching tutorials and reading other information for beginners...but at my age there's definitely a bit of a learning curve. Thanks again.