Help With a formula

Question

Hello ,

I have to select the min of dates based on the first occurence of a value for example

Type|StartDt|

S|
D|1/4/2017
D|1/6/2017
S|
D|2/4/2017
D|2/2/2017

In this for every S row i would have to fill in the Min date like for the 1st row formula would return date as 1/4/2017 , i want to run the Min as Min(from the s row to the occurrence of the next s row). Currently was trying to use MIN(G3,CELL("address",INDEX(A4:A100,MATCH("S",A4:A100,0)))). Here but the result of the Cell Formula would Return as "$A$4" within quotes hence the Min doesnt work

Any ideas ?

Also i would want the first parameter of the range as dynamic like Index ( A of Current row +1 ) so that it start looking from the next row rather than the current row. I am able to get the Row as Row()+1 but how do i pass this to the range like Index("A"&Row()+1,"A100") , how to get this working

Appreciate your time

Thanks
Prajith