Lastest Date in Row Match to Column

[coccio]

	Original	31-Jul	31-Aug	24-Sep	Percentage
5000	4	5	6.5	7	=(E2-B2)/B2
5500	5	6	7	8
6000	11	10	9	8.5
6500	15	16	14	16

In the percentage cell F2 Looking to get the latest date in the row so in this case it would be 24-Sep then using a formula I would like to get a percentage of (7-4/4) or (E2-B1/B1). So the formula would identify the latest date and use that column to calculate the percentage

 

[JoeMo]

Book1
	A	B	C	D	E	F
1		Original	31-Jul	31-Aug	24-Sep	Percentage
2	5000	4	5	6.5	7	75.00%
3	5500	5	6	7	8	60.00%
4	6000	11	10	9	8.5	-22.73%
5	6500	15	16	14	16	6.67%
Superpave Template (2)

Cell Formulas
Range	Formula
F2:F5	F2	=(INDEX($C2:$E2,1,MATCH(MAX($C$1:$E$1),$C$1:$E$1,0))-$B2)/$B2

 

[coccio]

Thank you that worked out great

 

[JoeMo]

Thank you that worked out great

You are welcome - thanks for the reply.