Hello, I am trying to write a formula that calculates the average number of working days between a date in column Q and another date in column T, based on the following conditions:


The value in T falls within date range 02/01/2012 - 29/01/2012
The value in column Q is not blank
The value in column F is "Yes"

I have tried to write this using AVERAGEIFS but I don't know how to factor in the date condition for column T.....please can anyone assist?

Many Thanks