Count networkdays when value in another column changes

[bchager]

Hello all -

Hoping someone can assist. Considering the data below, when the Request ID changes, I would like for Excel to return the number of work days that have passed by looking at the DispositionDate column. For example; 5 work days passed while Request ID 177 was being approved. Thoughts?

Request ID	Approver	Action	DispositionDate
177	John	Approve	3/8/2016
177	Mary	Approve	3/14/2016
178	Keith	Approve	3/3/2016
178	Dave	Approve	3/8/2016
178	Linda	Approve	4/7/2016

<colgroup><col width="170" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6217;"> <col width="165" style="width: 124pt; mso-width-source: userset; mso-width-alt: 6034;"> <col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <tbody> </tbody>

 

[Eric W]

Welcome to the forum.

Try:

	A	B	C	D	E
1	Request ID	Approver	Action	DispositionDate
2	177	John	Approve	3/8/2016
3	177	Mary	Approve	3/14/2016	5
4	178	Keith	Approve	3/3/2016
5	178	Dave	Approve	3/8/2016
6	178	Linda	Approve	4/7/2016	26

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula E2 =IF(A3=A2,"",NETWORKDAYS(VLOOKUP(A2,$A$1:$D2,4,0),D2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>