Average time from date requested to date resolved

[PRODBMO]

example:
DATE:	REQUESTED BY:	DATE RESOLVED	AVERAGE WAIT			AVERAGE TIME REQUEST
	7/11/2014	8/20/2014	?			#NAME?

<tbody>
</tbody><colgroup><col><col span="2"><col><col><col><col></colgroup>

 

[NeonRedSharpie]

Why an average wait if there is only one set of start and end?

 

[ParamRay]

.
.

Suppose your "requested" date is in cell A2 and your "resolved" is in cell C2 (as in your example). Then the days elapsed between the two dates will simply be =C2-A2.

Fill that formula down the the last row of data and then use an AVERAGE function to return the average.

 

[PRODBMO]

Thank you. Also, suppose I want to deduct the weekends. example: Saturday and Sunday?

.

Suppose your "requested" date is in cell A2 and your "resolved" is in cell C2 (as in your example). Then the days elapsed between the two dates will simply be =C2-A2.

Fill that formula down the the last row of data and then use an AVERAGE function to return the average.

 

[PRODBMO]

Thank you. Also, suppose I want to deduct the weekends. example: Saturday and Sunday?