Untitled.png

Help.xlsx


Hopefully everyone will understand this picture. Any formula or vba for this?

I understand the first part:

=INDEX(Sheet1!D:D, MATCH(G719, Sheet1!H:H, 0))

but the date range is hard. i keep getting errors.