Help with formula please, if two values match calculate the difference between 2 dates

[Newbie73]

Hello, I need help creating a formula, example sheet:

Test4.xlsx

The goal is to if a value in column D matches the exact same value in column A the calculate the difference, in days, of the respective dates (as in, the same row date as the values). I've done the example sheet results in column G

Details:

Values from A and D won't be in order, so they need to be matched and then calculate the dates in front of the respectice rows for each A and D value;
Dates can change in both ways, as in sometimes the date in B might be more recent than the one in column E or vice versa;
Sometimes there might not be a match between A and D and sometimes there might not be a date, so ideally to ignore/blank cell this situations please

Thank you in advance for your help! Let me know if you need any more information or if I didn't explain something correctly.

 

[hagia_sofia]

So, the other way round then:

=LET(
a,XLOOKUP(D2:D15,A2:A15,B2:B15)-E2:E15,
IFNA(IF(a>=0,"",ABS(a)),""))

But what does row 14 mean - should it not be blank too?

 

[Newbie73]

Indeed it should! Missed that one, that seems to do the trick, will test it further.

Thank you again, you're a star! Hopefully one day will get to that excel level