Who is Participating?

Just use an AVERAGEIFS function like you already have but with the average of the dates, rather than the number of days - then deduct that result from B10 and you'll get the average days as required, i.e. using this formula