EXCEL DATE - If Series Contains Date, the Count!

[bevo993071]

First off, thank you for your help and taking the time to read this. Here is the situation I am trying to solve: I have two date/time stamps per transport unique identifier, I am trying to write a formula that says if on a given date, how many active transports occurred that were not outsourced? Below is an example of what a finished product would look like.

Activated	Deactivated	Outcome		Date	Utilization
07/28/2014 08:23	07/28/2014 17:09	Completed		07/28/2014	2
07/28/2014 08:01	07/28/2014 16:06	Completed		07/29/2014	0
08/02/2014 13:37	08/02/2014 21:55	Completed		07/30/2014	0
08/02/2014 22:20	08/03/2014 01:32	Completed		07/31/2014	0
08/04/2014 18:32	08/04/2014 22:55	Outsourced		08/01/2014	0
				08/02/2014	2
				08/03/2014	1
				08/04/2014	0

<tbody>
</tbody>

Thank you in advance for your help

 

[James006]

Hi,

In cell F2 for Utilization, you could test : =SUMPRODUCT((INT($A$2:$A$6)>=E2)*(INT($B$2:$B$6)<=E2)*($C$2:$C$6<>"Outsourced"))

HTH