Auto Generating Data with Multiple Conditions

Hi Everyone,

I would like to ask some help. As much as I would like to do it in regular Excel, I think this will only solved by using Macro.

I want to automatically show the same data BUT those who are under 10/15/2016 or every 15th, 30th, 31st of the month. It is like filtering those who are under those dates only.

Thank you so much in advance.


EMP NUMBER ACCOUNT NAME STATUS DATE
1090 OUTBOUND NAME 1 AGENT 10/5/2016
240 OUTBOUND NAME 2 AGENT 10/5/2016
730 OUTBOUND NAME 3 AGENT 10/5/2016
2631 OUTBOUND NAME 4 AGENT 10/5/2016
1090 OUTBOUND NAME 1 AGENT 10/7/2016
240 OUTBOUND NAME 2 AGENT 10/7/2016
730 OUTBOUND NAME 3 AGENT 10/7/2016
2631 OUTBOUND NAME 4 AGENT 10/7/2016
1090 OUTBOUND NAME 1 AGENT 10/14/2016
240 OUTBOUND NAME 2 AGENT 10/14/2016
730 OUTBOUND NAME 3 AGENT 10/14/2016
2631 OUTBOUND NAME 4 AGENT 10/14/2016
1090 OUTBOUND NAME 1 AGENT 10/15/2016
240 OUTBOUND NAME 2 AGENT 10/15/2016
730 INBOUND NAME 3 AGENT 10/15/2016
2631 INBOUND NAME 4 AGENT 10/15/2016

No macro

Assuming the haeding are row 1 and starts from col.A, so dates are in Col.E.
Also H1:H2 are blank, if not, any blank 2 vertical consecutive cells.

1) H2 formula: =(E2<=DATE(YEAR(NOW()),10,15))+(OR(DAY(E2)=15,E2=EOMONTH(E2,0)))
2) select A1
3) click on [Advanced Filter] on [Data] ribbon
4) click on "Criteria Range" box and select H1:H2 then click on "OK"