VBA查找/查找匹配日期变量的值，并返回其旁边的日期

I can't seem to solve what seems to be a minor issue. I basically need to open another file, match the datetime stored in a variable with a date in the opened file, then return the datetime four cells to the right.I can't seem to solve what seems to be a minor