return date when current value most recently occured

Hey guys,

I've been trying to figure this one out to no avail. I have a spreadsheet with sports results. I want column E to calculate number of days that have elapsed since the home teams last match. I'm stuck because the current home team may have played away in their last game, but maybe not. So they will have appeared in either column b or c.

Data in spreadsheet as follow
column A: date
b: home team name
c: away team name
d: result (1= home win)
e: the problem column

I've attached a simplified version of the spreadsheet. Any help would be mightily appreciated.

lastdate.xlsx

So in row 16, d is the home team and b is the away team. therefore the value in E16 should be 12, since twelve days have elapsed since the home team's (d) last match, which was on may 12.

For row E15, the value would also be 12, since twelve days have elapsed since c's last match. I tried using a vlookup function, but couldn't get the result i wanted

Outstanding