Need Help

[nbkqsj7]

Hello All,

I am looking for VBA to count my data on following conditions

The value should reflect in Cell O2 (Count if in Column M date is less than or Equal to today Column D is not equal to Validation )
The value should reflect in Cell P2 (Count if in Column M date is less than or Equal to today and Colum B is not blank and Column D is not equal to Validation )
The value should reflect in Cell Q2 (Count if in Column M date is less than or Equal to today and Colum B is blank and Column D is not equal to Validation )

The value should reflect in Cell O3 (Count if in Column M date is Equal to Tomorrow ( Excluding Saturday Sunday) Column D is not equal to Validation )
The value should reflect in Cell P3 (Count if in Column M date is Equal to Tomorrow ( Excluding Saturday Sunday) Column D is not equal to Validation and Colum B is not blank )
The value should reflect in Cell Q3 (Count if in Column M date is Equal to Tomorrow ( Excluding Saturday Sunday) and Column D is not equal to Validation and Colum B is blank )

The value should reflect in Cell O4 (Count if in Column M date is Equal to Tomorrow+1 ( Excluding Saturday Sunday) Column D is not equal to Validation )
The value should reflect in Cell P4 (Count if in Column M date is Equal to Tomorrow +1 ( Excluding Saturday Sunday) Column D is not equal to Validation and Colum B is not blank )
The value should reflect in Cell Q4 (Count if in Column M date is Equal to Tomorrow +1 ( Excluding Saturday Sunday) and Column D is not equal to Validation and Colum B is blank )

I am attaching a image to get better help..

Thanks in advance

 

[kvsrinivasamurthy]

If Column D is validated how it is not equal to validation. Where is validation list.

 

[bebo021999]

O2:

=COUNTIFS($M$2:$M$16,"<=" & TODAY()+ROW(1:1)-1,$D$2:$D$16,"<>Validation")

P2:

=COUNTIFS($M$2:$M$16,"<=" & TODAY()+ROW(1:1)-1,$D$2:$D$16,"<>Validation",$B$2:$B$16,"<>")

Q2:
=O2-P2
Drag down

 

[nbkqsj7]

O2:

=COUNTIFS($M$2:$M$16,"<=" & TODAY()+ROW(1:1)-1,$D$2:$D$16,"<>Validation")

P2:

=COUNTIFS($M$2:$M$16,"<=" & TODAY()+ROW(1:1)-1,$D$2:$D$16,"<>Validation",$B$2:$B$16,"<>")

Q2:
=O2-P2
Drag down

Thank you for your help.. trying to implement