Jeurng Pembunuh
New Member
- Joined
- Mar 13, 2019
- Messages
- 1
i would like to calculate how many item outstanding will be due on weekend in N/A and blank in the range.
[TABLE="class: grid, width: 1900"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Mail No.[/TD]
[TD]Date Received[/TD]
[TD]Type[/TD]
[TD]Forwarded Date[/TD]
[TD]Response[/TD]
[TD]Response Date[/TD]
[TD]Due Date[/TD]
[TD]Day Process[/TD]
[TD]Status[/TD]
[TD]Days Overdue[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]SSP-PDP2-WTRAN-856277[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]09/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]8[/TD]
[TD]Responded[/TD]
[TD]-6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]SSP-PDP2-WTRAN-856276[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]15/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]14[/TD]
[TD]Responded[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]SSP-PDP2-WTRAN-856275[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]15/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]14[/TD]
[TD]Responded[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]SSP-PDP2-WTRAN-856274[/TD]
[TD]12/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]26/03/2019[/TD]
[TD]2[/TD]
[TD]Outstanding[/TD]
[TD]-12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]SSP-PDP2-WTRAN-856273[/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]25/03/2019[/TD]
[TD]3[/TD]
[TD]Outstanding[/TD]
[TD]-11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SSP-PDP2-WTRAN-856271[/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD]25/03/2019[/TD]
[TD]0[/TD]
[TD]Responded[/TD]
[TD]-14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]SSP-PDP2-WTRAN-856272[/TD]
[TD]10/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]24/03/2019[/TD]
[TD]4[/TD]
[TD]Outstanding[/TD]
[TD]-10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SSP-PDP2-WTRAN-856271[/TD]
[TD]10/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Info[/TD]
[TD]N/A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SSP-PDP2-WTRAN-856270[/TD]
[TD]09/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]23/03/2019[/TD]
[TD]5[/TD]
[TD]Outstanding[/TD]
[TD]-9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SSP-PDP2-WTRAN-856269[/TD]
[TD]01/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]15/03/2019[/TD]
[TD]13[/TD]
[TD]Outstanding[/TD]
[TD]-1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 1900"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Mail No.[/TD]
[TD]Date Received[/TD]
[TD]Type[/TD]
[TD]Forwarded Date[/TD]
[TD]Response[/TD]
[TD]Response Date[/TD]
[TD]Due Date[/TD]
[TD]Day Process[/TD]
[TD]Status[/TD]
[TD]Days Overdue[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]SSP-PDP2-WTRAN-856277[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]09/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]8[/TD]
[TD]Responded[/TD]
[TD]-6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]SSP-PDP2-WTRAN-856276[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]15/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]14[/TD]
[TD]Responded[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]SSP-PDP2-WTRAN-856275[/TD]
[TD]01/01/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]15/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]14[/TD]
[TD]Responded[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]SSP-PDP2-WTRAN-856274[/TD]
[TD]12/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]26/03/2019[/TD]
[TD]2[/TD]
[TD]Outstanding[/TD]
[TD]-12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]SSP-PDP2-WTRAN-856273[/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]25/03/2019[/TD]
[TD]3[/TD]
[TD]Outstanding[/TD]
[TD]-11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SSP-PDP2-WTRAN-856271[/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD]25/03/2019[/TD]
[TD]0[/TD]
[TD]Responded[/TD]
[TD]-14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]SSP-PDP2-WTRAN-856272[/TD]
[TD]10/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]24/03/2019[/TD]
[TD]4[/TD]
[TD]Outstanding[/TD]
[TD]-10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]SSP-PDP2-WTRAN-856271[/TD]
[TD]10/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Info[/TD]
[TD]N/A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SSP-PDP2-WTRAN-856270[/TD]
[TD]09/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]23/03/2019[/TD]
[TD]5[/TD]
[TD]Outstanding[/TD]
[TD]-9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]SSP-PDP2-WTRAN-856269[/TD]
[TD]01/03/2019[/TD]
[TD]Workflow Transmittal[/TD]
[TD]03/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]15/03/2019[/TD]
[TD]13[/TD]
[TD]Outstanding[/TD]
[TD]-1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]