how to select lines in an array in excel based on a date criteria

How to do the following selection of lines in an array in Excel: I have an array of employees, with salary revision dates and salary amounts. So I may have several lines for one employee, correspond...