How to calculate number of due on weekend exclude N/A and blank in that range

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.


ItemMail No.Date ReceivedTypeForwarded DateResponseResponse DateDue DateDay ProcessStatusDays OverdueRemarks
9SSP-PDP2-WTRAN-85627701/01/2019Workflow Transmittal03/01/201909/01/201915/01/20198Responded-6
8SSP-PDP2-WTRAN-85627601/01/2019Workflow Transmittal03/01/201915/01/201915/01/201914Responded0
7SSP-PDP2-WTRAN-85627501/01/2019Workflow Transmittal03/01/201915/01/201915/01/201914Responded0
6SSP-PDP2-WTRAN-85627412/03/2019Workflow Transmittal03/01/201926/03/20192Outstanding-12
5SSP-PDP2-WTRAN-85627311/03/2019Workflow Transmittal03/01/201925/03/20193Outstanding-11
SSP-PDP2-WTRAN-85627111/03/2019Workflow Transmittal03/01/201911/03/201925/03/20190Responded-14
11/03/2019Workflow Transmittal03/01/2019
4SSP-PDP2-WTRAN-85627210/03/2019Workflow Transmittal03/01/201924/03/20194Outstanding-10
3SSP-PDP2-WTRAN-85627110/03/2019Workflow Transmittal03/01/2019N/AN/AN/AInfoN/A
2SSP-PDP2-WTRAN-85627009/03/2019Workflow Transmittal03/01/201923/03/20195Outstanding-9
1SSP-PDP2-WTRAN-85626901/03/2019Workflow Transmittal03/01/201915/03/201913Outstanding-1

<tbody>
</tbody>
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,214,829
Messages
6,121,826
Members
449,051
Latest member
excelquestion515

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