Ms Excel If the name matches and

Ms Excel :If the name matches and if the input date falls in between two columns of another sheet , i want to return some values
Sheet1 : Salary Average CalculationDateEmployee Name1Employee Name2Employee Name3Employee Name4Emp
admin5天前
50