Workday formula required based on depending dates

[exceluser9]

Hi Team

I have below data and im using formula =WORKDAY(C2,1) to calculate the workdate based on the received date.

However, I have 3 depending activities for which the workday should calculate only after the depending task is completed. and it will be next workday after the depending task is completed. If the dependent tasks arent completed then the workday column should remain blank.

For each SL # there will be 8 task out of 8 the 3 are dependent task i.e Logo, agreement and Number

Agreement is dependent on Temp completion, Logo is dependent on Number completion and Number is dependent on other 6 tasks. The workday for Number should check for the latest date of 6 activities and calculate the next workday.

This is a sample data and the data is in 2000 rows with similar format. And the formula should work only if it finds 8 tasks for a SL # anything less than 8 it should remain blank.

Thanks in advance

[TABLE="width: 466"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]SL #[/TD]
[TD]Files[/TD]
[TD]Email received[/TD]
[TD]Workday calculation[/TD]
[TD]Task completed[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]03/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]05/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]01/07/2019[/TD]
[TD]12/07/2019[/TD]
[TD]17/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]01/07/2019[/TD]
[TD]04/07/2019[/TD]
[TD]14/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]01/07/2019[/TD]
[TD]15/07/2019[/TD]
[TD]11/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]03/07/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E
1	SL #	Files	Email received	Workday calculation	Task completed
2	18137	Document	7/1/2019	7/2/2019	7/3/2019
3	18137	Report	7/1/2019	7/2/2019	7/5/2019
4	18137	Protocol	7/1/2019	7/2/2019	7/6/2019
5	18137	Due	7/1/2019	7/2/2019	7/6/2019
6	18137	Logo	7/1/2019	7/12/2019	7/17/2019
7	18137	Agreement	7/1/2019	7/4/2019	7/14/2019
8	18137	Number	7/1/2019	7/15/2019	7/11/2019
9	18137	Temp	7/1/2019	7/2/2019	7/3/2019
Sheet19

Cell Formulas
Range	Formula
D2	=IF(COUNTIFS(A:A,A2,E:E,">0")<8,"",WORKDAY(CHOOSE(MATCH(B2,{"Document","Report","Protocol","Due","Logo","Agreement","Number","Temp"},0),C2,C2,C2,C2,SUMIFS(E:E,A:A,A2,B:B,"Number"),SUMIFS(E:E,A:A,A2,B:B,"Temp"),AGGREGATE(14,6,E$2:E$1000/((A$2:A$1000=A2)*(B$2:B$1000<>"Logo")*(B$2:B$1000<>"Number")),1),C2),1))

You didn't say which 6 activities we need to check for Number, but I assumed everything except Number itself and Logo. It seems I could shorten this a bit, so I may look at it a bit more. Let me know how this works so far.

 

[Eric W]

A bit shorter, but requires Control+Shift+Enter when you enter it in the formula bar:

=IF(COUNTIFS(A:A,A2,E:E,">0")<8,"",WORKDAY(IFERROR(1/(1/MAX(SUMIFS(E:E,A:A,A2,B:B,CHOOSE(MATCH(B2,{"Logo","Agreement","Number"},0),"Number","Temp",{"Document","Report","Protocol","Due","Agreement","Temp"})))),C2),1))

The array constant in red are the 6 activities we need to check for Number.

 

[exceluser9]

Thank you Eric I will check.

Also I mentioned that the formula should work only if it finds 8 tasks for a SL # anything less than 8 it should remain blank.

Can it calculate workday 1? Instead of blank for the tasks lesser than 8?

 

[Eric W]

Which tasks do you want to show WORKDAY( ,1) and which do you want to show as blank if there are less than 8 tasks?

 

[exceluser9]

Hi Eric,

Thank you, your assumption on 6 task calculation is correct.

Formula works fine but when i delete any date in task completed every workday calculation goes blank. There should be blank only for 3 activities. If task completed is blank for Temp then workday calculation for Agreement should be blank. If task completed is blank for Supplier then workday calculation for Logo should be blank. If any of the 6 task completion date is blank then work calculation for supplier should be blank. For rest workday should calculate even if task completion date is blank.

The condition should be like If the SL# is same then check for dependent tasks which is Agreement , Logo, Number and 6 task completion date for Number

Agreement dependent on Temp
Logo dependent on Number
Number dependent on 6 tasks completed date and the workday will be next day after the last task day completion.

If any of the dependent tasks are not found for respective files then calculate workday 1. If the dependent task is found and the task completion date criteria is not met the keep work calculation row as blank. Thanks in advance, below is an example

[TABLE="width: 488"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SL #[/TD]
[TD]Files[/TD]
[TD]Email received[/TD]
[TD]Workday calculation[/TD]
[TD]Task completed[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]03/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]05/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]01/07/2019[/TD]
[TD]12/07/2019[/TD]
[TD]17/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]01/07/2019[/TD]
[TD]04/07/2019[/TD]
[TD]11/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]01/07/2019[/TD]
[TD]12/07/2019[/TD]
[TD]11/07/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]03/07/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]03/07/2019[/TD]
[TD]05/07/2019[/TD]
[TD]09/07/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]03/07/2019[/TD]
[TD]05/07/2019[/TD]
[TD]09/07/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]12/08/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]12/08/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]06/08/2019[/TD]
[TD]15/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]06/08/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]12/08/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]12/08/2019[/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]17/08/2019[/TD]
[TD]19/08/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]12/08/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]06/08/2019[/TD]
[TD]08/08/2019[/TD]
[TD]14/08/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]03/07/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]05/07/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD]06/07/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Temp[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Your latest example threw a monkey wrench in my plans. I had a nice formula, but it didn't work on this data set, mainly because you have duplicate values. For example for SL 18134, you have Document twice. Do you have the MAXIFS function available on your version of Excel? It's in Excel 365. If you do, I can easily repair the formula. If not, it will take something more complicated.

 

[Eric W]

Here's how it might look without MAXIFS:

Excel 2012

	A	B	C	D	E
SL #	Files	Email received	Workday calculation	Task completed
Document
Report
Protocol
Due
Logo
Agreement
Number
Temp
Modify calender
Modify machine
Report
Protocol
Number
Logo
Agreement
Due
Modify Loan
Form
Document
Document
Report
Protocol
Due
Logo
Agreement
Number
Temp

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/3/2019[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/5/2019[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/6/2019[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/6/2019[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/12/2019[/TD]
[TD="align: right"]7/17/2019[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/4/2019[/TD]
[TD="align: right"]7/11/2019[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/12/2019[/TD]
[TD="align: right"]7/11/2019[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]18137[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/3/2019[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]167[/TD]

[TD="align: right"]7/2/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]7/3/2019[/TD]
[TD="align: right"]7/9/2019[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]167[/TD]

[TD="align: right"]7/3/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]7/4/2019[/TD]
[TD="align: right"]7/9/2019[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]8/7/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]8/7/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="align: right"]8/15/2019[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]7/3/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]8/7/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]1647[/TD]

[TD="align: right"]8/17/2019[/TD]
[TD="align: right"]8/19/2019[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]8/7/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]8/6/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]8/7/2019[/TD]
[TD="align: right"]8/14/2019[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/3/2019[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/5/2019[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/6/2019[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/6/2019[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]

[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=8EA9DB]#8EA9DB[/URL] , align: right"]7/3/2019[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]8/15/2019[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]18134[/TD]

[TD="align: right"]7/1/2019[/TD]
[TD="align: right"]7/2/2019[/TD]
[TD="align: right"]7/2/2019[/TD]

</tbody>

Sheet11​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IFERROR(CHOOSE(MATCH(B2,{"Logo","Agreement","Number"},0),IFERROR(WORKDAY(1/(1/AGGREGATE(14,6,$E$2:$E$100/(($A$2:$A$100=A2)*($B$2:$B$100="Number")),1)),1),""),IFERROR(WORKDAY(1/(1/AGGREGATE(14,6,$E$2:$E$100/(($A$2:$A$100=A2)*($B$2:$B$100="Temp")),1)),1),""),IFERROR(WORKDAY(AGGREGATE(14,6,$E$2:$E$100/(($A$2:$A$100=A2)*($B$2:$B$100={"Document","Report","Protocol","Due","Agreement","Temp"})),1)/(PRODUCT(SUMIFS(E:E,A:A,A2,B:B,{"Document","Report","Protocol","Due","Agreement","Temp"}))>0),1),"")),WORKDAY(C2,1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



No CSE needed, but you do need to go in and change the bottom row from 100 to some number past the bottom row of your data. Some of the rows do not match your latest example, but I think they should be OK. If not, let me know.

 

[exceluser9]

Hi Eric.
I'm really sry duplicate in 18134 (Document) is my mistake. There won't be duplicate in data.

 

[exceluser9]

Hi Eric,

I tried the formula which you gave and I have removed the duplicates. But for agreement in SL# 18134 comes as blank in workday calculation. It should display next workday if the depending task is not there. Example if temp is not available then it should calculate next workday for Agreement. Rest works fine Below is the result i got when i input the formula.

[TABLE="width: 488"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SL #[/TD]
[TD]Files[/TD]
[TD]Email received[/TD]
[TD]Workday calculation[/TD]
[TD]Task completed[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]03/07/2019[/TD]
[TD]04/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]03/07/2019[/TD]
[TD]04/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]06/08/2019[/TD]
[TD]07/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]06/08/2019[/TD]
[TD]07/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]06/08/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]06/08/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]06/08/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]06/08/2019[/TD]
[TD]07/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]17/08/2019[/TD]
[TD]19/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]06/08/2019[/TD]
[TD]07/08/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]01/07/2019[/TD]
[TD]02/07/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]01/07/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]