Lookup dates in a row

Hi,

I have a sheet that records products ordered and whether they arrived or not against a date.

I'm looking for a way to do a vlookup on a value in a range and then find the first occurence of a non arrival, the last occurence, return the dates of these and then count the number of occurences of non arrivals. Return the values in cells b15, c15 and d15

Could anyone help me how to do this please? File attached.

Many thanks.