VBA date filter,how to add one more filter

[2avrham]

Hi,

I have the next VBA code that filtered between two dates.
I wander how can I modify it to bring me also the "(blank)" cells that I have ( I need them too).

Sub filter_24()
Dim StartDate As Date, EndDate As Date
StartDate = DateAdd("h", "-16", Date)
EndDate = DateAdd("h", "8", Date)
Range("A5:T5").AutoFilter Field:=17, _
Criteria1:=">=" & StartDate, _
Operator:=xlAnd, _
Criteria2:="<=" & EndDate


any idea how to do this?

Few rows from my column table:

[TABLE="width: 131"]
<tbody>[TR]
[TD]6/2/2018 16:32[/TD]
[/TR]
[TR]
[TD]6/10/2018 8:27[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
[TR]
[TD]6/8/2018 23:48[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]


Thanks!!

 

[jmacleary]

Hi there. You cant directly have more than 2 filters set. However, if you can add an extra column to your table, you could put in a formula like this (I assumed your date field is in column Q):
=OR(Q5="",AND(Q5>=NOW()-16/24,Q5<=NOW()+8/24)) and filter on this column for true.