Workday formula required based on depending dates

exceluser9

Active Member
Joined
Jun 27, 2015
Messages
388
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]
 
I'm still seeing some issues with duplicates. In your latest example, I see 18134 Due twice, and 18134 Agreement twice, and 18134 Number twice. For now, I'm going to assume that those are typos. If there are no duplicates, we can go back to the simpler formula. Try this one:

Excel 2012
ABCDE
SL #FilesEmail receivedWorkday calculationTask completed
Document
Report
Protocol
Due
Logo
Agreement
Number
Temp
Modify calender
Modify machine
Logo
Agreement
Due
Modify Loan
Form
Document
Report
Protocol
Logo
Number

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><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/3/2019[/TD]
[TD="align: right"]7/4/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="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="align: right"][/TD]

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

[TD="align: right"]8/6/2019[/TD]
[TD="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/7/2019[/TD]
[TD="align: right"]8/12/2019[/TD]

[TD="align: center"]15[/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"]16[/TD]
[TD="align: right"]18134[/TD]

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

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

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

[TD="align: center"]18[/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"]19[/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"]20[/TD]
[TD="align: right"]18134[/TD]

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

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

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

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

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

</tbody>
Sheet11


[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: <a href="]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: <a href="]D2
[/TH]
[TD="align: left"]=IFERROR(CHOOSE(MATCH(B2,{"Logo","Agreement","Number"},0),IFERROR(WORKDAY(1/(1/SUMIFS(E:E,A:A,A2,B:B,"Number")),1),""),WORKDAY(1/(1/SUMIFS(E:E,A:A,A2,B:B,"Temp")),1),IFERROR(WORKDAY(MAX(1/(1/SUMIFS(E:E,A:A,A2,B:B,{"Document","Report","Protocol","Due","Agreement","Temp"}))),1),"")),WORKDAY(C2,1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



On this one, I changed it so that if Agreement can't find Temp, it shows next workday. If Logo can't find Number, it shows as blank. And if Number can't find one of its 6 subordinate tasks, it shows blank. Everything else shows next workday.

Let me know how this works.
 
Last edited:
Upvote 0

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Hi Eric,

I tried the formula but for SL# 18137 on Agreement its gives the date even before the task for Temp is completed. It should be blank, could you help. Thanks in advance

For SL # 18134 it works fine.

[TABLE="width: 366"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SL#[/TD]
[TD]Files[/TD]
[TD]Email reccived[/TD]
[TD]Workday calculation[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi Eric,

Also i have noticed that for SL# 18134 the date for Number is no populating once 6 task is completed. Is it because Form is not part of "Document","Report","Protocol","Due","Agreement","Temp"?
 
Upvote 0
You're giving me mixed messages:
exceluser9 said:
But for agreement in SL# 18134 comes as blank in workday calculation. It should display next workday if the depending task is not there.

Hi Eric,

I tried the formula but for SL# 18137 on Agreement its gives the date even before the task for Temp is completed. It should be blank, could you help. Thanks in advance

I'll go back to the original method.

exceluser9 said:
Also i have noticed that for SL# 18134 the date for Number is no populating once 6 task is completed. Is it because Form is not part of "Document","Report","Protocol","Due","Agreement","Temp"?

Yes. Should Temp be the equivalent of Form? Should I populate Number if I get any 6 out of
"Document","Report","Protocol","Due","Agreement","Temp","Form"? Exactly what conditions are necessary to populate Number?
 
Upvote 0
Hi Eric.

Nope, temp is not equivalent to Form. Temp is equivalent only to Agreement. Date for agreement should be populated only if temp has a completed date, if not it should remain blank.

However, if temp is not part of the respective SL# only then Agreement should calculate next workday.

Yes please populate Number if you get any 6 out of "Document","Report","Protocol","Due","Agreement","Temp","Form".
 
Upvote 0
Try this in D2:

Code:
=IFERROR(CHOOSE(MATCH(B2,{"Logo","Agreement","Number"},0),IFERROR(WORKDAY(1/(1/SUMIFS(E:E,A:A,A2,B:B,"Number")),1),""),IF(COUNTIFS(A:A,A2,B:B,"Temp")=0,NA(),IFERROR(WORKDAY(1/(1/SUMIFS(E:E,A:A,A2,B:B,"Temp")),1),"")),IFERROR(WORKDAY(MAX(SUMIFS(E:E,A:A,A2,B:B,{"Document","Report","Protocol","Due","Agreement","Temp","Form"})),1)/(SUM(COUNTIFS(A:A,A2,B:B,{"Document","Report","Protocol","Due","Agreement","Temp","Form"}))>=6),"")),WORKDAY(C2,1))
 
Upvote 0
HI Eric,

Apologies, I think there is a miscommunication. Workday calculation for "Number" should be populated only if 6 tasks are completed out of 7. Also workday calculation for "Number" is populated as 02/01/1900 instead of blank. Sry again.

[TABLE="width: 373"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SL#[/TD]
[TD]Files[/TD]
[TD]Email reccived[/TD]
[TD]Workday calculation[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]07/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]07/01/2019[/TD]
[TD]02/01/1900[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]08/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]08/06/2019[/TD]
[TD]02/01/1900[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Also I require one more formula for a different data where there is one more addition i.e Logo S. Where the workday calculation for it should happen once the completed date for "Number" is found until then "Logo S" should be blank and once "Logo S" has a completed date "Logo" should get a workday calculation until then it should remain blank. Below is the example of the data and expected result. Since its a similar logic im including in same thread. Thank you for your support. Appreciate it:)

[TABLE="width: 478"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SL#[/TD]
[TD]Files[/TD]
[TD]Email reccived[/TD]
[TD]Workday calculation[/TD]
[TD]Completed date[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]07/01/2019[/TD]
[TD]15/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]07/01/2019[/TD]
[TD]10/03/2019[/TD]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]07/01/2019[/TD]
[TD]12/03/2019[/TD]
[TD]13/03/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo S[/TD]
[TD]07/01/2019[/TD]
[TD]14/03/2019[/TD]
[TD]14/03/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]08/06/2019[/TD]
[TD]14/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]08/06/2019[/TD]
[TD]12/06/2019[/TD]
[TD]12/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo S[/TD]
[TD]08/06/2019[/TD]
[TD]13/06/2019[/TD]
[TD]13/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
When you show your sample data, please show all columns. I am unable to replicate your results from post 17 without the "Completed Date" column. I assume you want the additional changes from post 18 incorporated into the same formula?
 
Upvote 0
HI Eric,

Please ignore post 18 for now, its a formula for new requirement and i will update it with details once this task is completed.

Below is the example for post 17 with completed date column.
Workday calculation for "Number" should be populated only if 6 tasks are completed out of 7. Also workday calculation for "Number" is populated as 02/01/1900 instead of blank with formula as per post 16




[TABLE="width: 468"]
<tbody>[TR]
[TD]SL#[/TD]
[TD]Files[/TD]
[TD]Email reccived[/TD]
[TD]Workday calculation[/TD]
[TD]Completed date[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Document[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD="align: right"]09/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Report[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD="align: right"]10/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Protocol[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD="align: right"]11/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Due[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD="align: right"]13/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Logo[/TD]
[TD]07/01/2019[/TD]
[TD]16/01/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Agreement[/TD]
[TD]07/01/2019[/TD]
[TD]10/01/2019[/TD]
[TD="align: right"]10/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Number[/TD]
[TD]07/01/2019[/TD]
[TD]14/01/2019[/TD]
[TD="align: right"]15/01/2019[/TD]
[/TR]
[TR]
[TD]18137[/TD]
[TD]Temp[/TD]
[TD]07/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD="align: right"]09/01/2019[/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify calender[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]167[/TD]
[TD]Modify machine[/TD]
[TD]07/03/2019[/TD]
[TD]08/03/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1647[/TD]
[TD]Modify Loan[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Form[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]11/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Document[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]12/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Report[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]13/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Protocol[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]18/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Logo[/TD]
[TD]08/06/2019[/TD]
[TD]24/06/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Number[/TD]
[TD]08/06/2019[/TD]
[TD]21/06/2019[/TD]
[TD="align: right"]22/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Agreement[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]20/06/2019[/TD]
[/TR]
[TR]
[TD]18134[/TD]
[TD]Due[/TD]
[TD]08/06/2019[/TD]
[TD]10/06/2019[/TD]
[TD="align: right"]18/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top