NETWORKDAYS + SUMPRODUCT Formula

Yes of course!

So by calculating the average Number of days between the Milestone 1 (SALT-in-a-Box sign-up) and the Milestone 3 ( The nexus survey), I want to be able with that formula, to evaluate on average how many days does a partner take to go from Milestone 1 to Milestone 3.

I will have multiple partners and thus I want the formula to consider every difference between those milestones.

The date will be put manually once the Milestone is completed by the partner.

So fort example by a quick look at the answer from the formula, I'll be able to say : On average, Partners take 40 days between those 2 steps.

Hope that helps, thanks a lot for your time.

-Guillaume