Searching Date Conditionally
There is an Excel file that teaches how to perform the Searching Date Conditionally operation.
Excel Professional Searching Date Conditionally
This workbook demonstrates searching date conditionally using VBA macros on a 35-row data layout.
Hope it is useful.