Sample Custom Price to Date

	A	B	C	D	E	F	G	H	I	J
1	SNO	ENTER-SYMBOL	DATES	HIGH	LOW	HIGHDATE	LOWDATE	CUSTOMPRICE	CUSTOMDATE
2		SUZLON	10/22/2007	422.19	74.65	1/9/2008	10/20/2008	320.0166667	?	Means when h2 falls in open close price range ?
3			10/21/2008	133.78	30.35	6/5/2009	3/12/2009	78.17	2/10/2009	H2 custom price must be in between C2, C3 dates
4			10/20/2009	87.6	42.1	1/12/2010	8/31/2010	78.52	8/2/2010	Please see comment
5			10/20/2010	55.28	31.22	10/25/2010	8/26/2011	54.02333333	7/27/2011
6			10/20/2011	35.9	13.54	10/31/2011	8/31/2012	33.46666667	8/1/2012
7			10/22/2012	24.75	5.23	2/6/2013	8/28/2013	14.29333333	7/29/2013
8			10/22/2013	33.74	7.58	6/12/2014	11/13/2013	8.663333333	10/21/2013
9			10/21/2014	28.79	0	3/19/2015	8/12/2015	10.42	7/13/2015	Solution is provided in I2
10			10/20/2015	23.18	0	11/2/2015	11/30/2015	22.13	11/2/2015
11			10/20/2016	20.43	11.02	5/22/2017	11/9/2016	13.52666667	10/10/2016
12			10/23/2017	15.89	4.64	11/1/2017	10/1/2018	14.31	9/3/2018
13			10/22/2018	7.71	1.88	3/6/2019	10/1/2019	5.543333333	9/3/2019
14			10/22/2019	5.56	1.56	7/6/2020	3/26/2020	2.433333333	2/25/2020
15			10/20/2020	8.68	2.62	7/6/2021	10/20/2020	2.86	9/21/2020
16			10/20/2021	12.03	5.42	1/18/2022	7/28/2022	6.476666667	6/28/2022
17			10/20/2022	33.15	6.95	10/20/2023	3/28/2023	8.683333333	2/27/2023
18			10/20/2023	86.04	30	9/12/2024	10/31/2023	#DIV/0!	10/18/2023
19			10/22/2024				10/23/2024
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100