Extracting a Date Range

[lbird2]

Sorry for the lousy table format.

I would like to extract from the left Jan-Dec data, only the numbers that start and end with the dates under the headings Start, Stop. The desired result is shown to the right.
Many thanks.

Jan-20​

Feb-20​

Mar-20​

Apr-20​

May-20​

Jun-20​

Jul-20​

Aug-20​

Sep-20​

Oct-20​

Nov-20​

Dec-20​

Start

Stop

Jan-20​

Feb-20​

Mar-20​

Apr-20​

May-20​

Jun-20​

Jul-20​

Aug-20​

Sep-20​

Oct-20​

Nov-20​

Dec-20​

28​

39​

55​

50​

53​

79​

35​

6​

15​

80​

22​

54​

Mar-20​

Oct-20​

55​

50​

53​

79​

35​

6​

15​

80​

41​

29​

48​

1​

27​

64​

35​

92​

82​

30​

63​

22​

Jan-20​

Nov-20​

41​

29​

48​

1​

27​

64​

35​

92​

82​

30​

63​

0​

43​

54​

39​

52​

43​

11​

51​

90​

32​

85​

37​

Apr-20​

Jun-20​

39​

52​

43​

55​

63​

8​

92​

33​

76​

84​

28​

39​

15​

58​

6​

Jun-20​

Dec-20​

76​

84​

28​

39​

15​

58​

6​

 

[lrobbo314]

Team Rank PQ.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	1/1/2020	2/1/2020	3/1/2020	4/1/2020	5/1/2020	6/1/2020	7/1/2020	8/1/2020	9/1/2020	10/1/2020	11/1/2020	12/1/2020		Start	Stop		Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20
2	28	39	55	50	53	79	35	6	15	80	22	54		3/1/2020	10/31/2020				55	50	53	79	35	6	15	80
3	41	29	48	1	27	64	35	92	82	30	63	22		1/1/2020	11/30/2020		41	29	48	1	27	64	35	92	82	30	63
4	0	43	54	39	52	43	11	51	90	32	85	37		4/1/2020	6/30/2020					39	52	43
5	55	63	8	92	33	76	84	28	39	15	58	6		6/1/2020	12/31/2020							76	84	28	39	15	58	6
Sheet5

Cell Formulas
Range	Formula
B1:L1	B1	=EOMONTH(A1,0)+1
Q2:AB5	Q2	=IF(AND(A$1>=$N2,A$1<=$O2),A2,"")

 

[lbird2]

Works great. Thank you very much!