Filter Date Range

Hi,

Can anyone advise me how to ignore an N.A date in my filtering command?
I would like only Tag Date with a date to be displayed. Thanks.

Thanks Xlnitwit for solving my problem.

Hi Xlnitwit,

My original Criteria formula will display the information with "N.A" date even the serial number isn't in the search list.
Is it possible to have the "N.A" data ONLY when the serial number is in the search list?

Originally Posted by xlnitwit

Do you only want N.A. for those results, or the other matching dates as well?

Yes, I want the N.A and other matching dates for s/no in the search list.

My initial code displayed those S/No with Tag Date N.A which are not in the search list.
For e.g. 0087 and 00263 was input to search for the info.
But 00239, 00203 and 00237 also appeared as they have the Tag Date of "N.A".

Capture1.JPG
Capture.JPG

Originally Posted by xlnitwit

Change the criteria formula in the previous workbook I posted to this
=AND(ISNUMBER(MATCH('Sheet 1'!H6,$B$6:$B$14,0)),OR(AND('Sheet 1'!E6>=$F$2,'Sheet 1'!E6<=$G$2),'Sheet 1'!E6="N.A"))

Thanks Xlnitwit.
It works. Appreciate your help.