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.

The last occurrence should be 16-3-15..isn't it?? and total occurrences are 10
Try these formula
B15=INDEX($A$1:$K$1,MIN(IF($B$3:$K$12="No",IF(ISODD(COLUMN($B$3:$K$12)),COLUMN($B$3:$K$12),""),""))-1)
C15=INDEX($A$1:$K$1,MAX(IF($B$3:$K$12="No",IF(ISODD(COLUMN($B$3:$K$12)),COLUMN($B$3:$K$12),""),""))-1)
These both are array formulas

D15=COUNTIF(B3:K12,"No")

Ok try this
B15=IFERROR(INDEX($A$1:$K$1,MIN(IF($B4:$K4="No",IF(ISODD(COLUMN($B4:$K4)),COLUMN($B4:$K4),""),""))-1),"")
C15=IFERROR(INDEX($A$1:$K$1,MAX(IF($B3:$K3="No",IF(ISODD(COLUMN($B3:$K3)),COLUMN($B3:$K3),""),""))-1),"")
D15==COUNTIF(B3:K3,"No")
All the three formulas copied down...and first two are array formulas...
Check attached!!

So you want to lookup 4th header??
No problems
Check attached