Formula to find value between rows with matching data

Hi All,   I'm trying to get a formula that retrieves an amount from Sheet 1 based on looking at the dates between rows specified for each persons ID. The problem I have is the format of data, as th...