Get Maximum and Minimum date

[MAHMUZ]

Dear`s
The attached file contain sample of my data and the result I am looking for, I am trying to write a formula to get the maximum or minimum date based range of amount and date.

Your help and support will always be appreciated.
BR

[AlKey]

Maybe this
Enter in I2 and copy down

Please Login or Register  to view this content.

v	A	B	C	D	E	F	G	H	I
1	Invoice Balance	7/1/2018	7/2/2018	7/3/2018	7/4/2018	7/5/2018	7/6/2018	7/7/2018
2	A	10.20	10.20	10.20	0.00	0.00	0.00	0.00	7/4/2018
3	B	30.35	30.35	30.35	30.35	30.35	30.35	30.35	7/7/2018
4	C	40.24	40.24	40.24	40.24	40.24	40.24	0.00	7/7/2018