E
Eager2Learn
I am still working with Month To Date data. Here is the formula I a
using to find the number of filled jobs during the current month.
=SUMPRODUCT((MONTH(J$3:J$1000)=MONTH(TODAY()))*(YEAR(J$3:J$1000)=YEAR(TODAY()))*(K$3:K$1000="Ne
Hire"))
Column J = Date Filled
Column K = New Hire or Transfer
Column L has a formula to calculate the number of days it took to fil
the position.
I would like to create a formula similiar to the one above, but I woul
like to find the average time it took to fill the NEW HIRE position
Month to Date.
Help.
Mik
using to find the number of filled jobs during the current month.
=SUMPRODUCT((MONTH(J$3:J$1000)=MONTH(TODAY()))*(YEAR(J$3:J$1000)=YEAR(TODAY()))*(K$3:K$1000="Ne
Hire"))
Column J = Date Filled
Column K = New Hire or Transfer
Column L has a formula to calculate the number of days it took to fil
the position.
I would like to create a formula similiar to the one above, but I woul
like to find the average time it took to fill the NEW HIRE position
Month to Date.
Help.
Mik