Locating a row in a table of data based on specified parameters

Hi - I'm looking for some formulas in the attached template to help me locate a date in a table of data, based either on specifying which of a succession of dates I am interested in [the first, second or Nth date] OR, more complicated, to locate a row containing a particular date after specifying some conditions to consider only some of the dates in the data rather than all of them...

Apologies for not framing this question with greater Excel specificity! Your help greatly appreciated.....