Column A has a run# and column AA has a date & time stamp. We can call this workbook Log. Example:

____A___AA___________
1___EK-01___10/19 17:50
2___EK-02___10/19 18:00
3___EK-03___10/19 18:17
4___EL-01___10/20 17:30
5___EL-02___10/20 17:55
6___EL-03___10/20 18:22

In a seperate workbook, I have the date in column D. In column E, I would like to extract the run# of the last run before 18:00 on that date. Example:

___D_____E
1__10/19__EK-01
2__10/20__EL-02

Any suggestions on how to do this?