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?
[TABLE="width: 467"]
<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>[TR]
[TD="class: xl66, width: 170, bgcolor: transparent"]Request ID[/TD]
[TD="width: 165, bgcolor: transparent"]Approver[/TD]
[TD="width: 155, bgcolor: transparent"]Action[/TD]
[TD="width: 132, bgcolor: transparent"]DispositionDate[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]177[/TD]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/8/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]177[/TD]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/14/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Keith[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/3/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Dave[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/8/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Linda[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]4/7/2016[/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 467"]
<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>[TR]
[TD="class: xl66, width: 170, bgcolor: transparent"]Request ID[/TD]
[TD="width: 165, bgcolor: transparent"]Approver[/TD]
[TD="width: 155, bgcolor: transparent"]Action[/TD]
[TD="width: 132, bgcolor: transparent"]DispositionDate[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]177[/TD]
[TD="bgcolor: transparent"]John[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/8/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]177[/TD]
[TD="bgcolor: transparent"]Mary[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/14/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Keith[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/3/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Dave[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]3/8/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]178[/TD]
[TD="bgcolor: transparent"]Linda[/TD]
[TD="bgcolor: transparent"]Approve[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9E1F2]#D9E1F2[/URL] , align: right"]4/7/2016[/TD]
[/TR]
</tbody>[/TABLE]