Excel Formula set in VBA modification needed

[ItalianPlatinum]

Hello - I am not quite able to modify an existing formula to accommodate a new change. I need to include another matching criteria in cell value B3 (current date) while the existing one B1 is yesterday's date.

 .Range("B5").Value = .[SUMPRODUCT(IFERROR(('NQ Ns'!$B$2:$B$2995='Ns COMPARE'!$B$1)/COUNTIFS('NQ Ns'!$B$2:$B$2995,'Ns COMPARE'!$B$1,'NQ Ns'!$A$2:$A$2995,'NQ Ns'!$A$2:$A$2995&""),0))]

the new file now has both dates so I need to be able to obtain a figure that presents both.

 

[ItalianPlatinum]

Hello was hoping if someone could help on this