filter out first day of the month Excel 2016

[sheller]

Hi there,
I need to filter out the 1st day of the month (Jan 1, Mar 1, etc) from a series of dates spanning several years and am having trouble doing this in an easy way using custom date filters. Happy to add a 'helper column if needed). From example below, I would want to filter out 12/1/2016, 1/1/2017 and 4/1/2017. Thank you!

[TABLE="width: 145"]
<colgroup><col></colgroup><tbody>[TR]
[TD]DEL_PERIOD_START[/TD]
[/TR]
[TR]
[TD="align: right"]7/6/2016[/TD]
[/TR]
[TR]
[TD="align: right"]7/29/2016[/TD]
[/TR]
[TR]
[TD="align: right"]7/29/2016[/TD]
[/TR]
[TR]
[TD="align: right"]7/29/2016[/TD]
[/TR]
[TR]
[TD="align: right"]7/29/2016[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2016[/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2017[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/2017[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/2017[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

One easy way is to add a "helper" column that pulls out the day, i.e.
=DAY(A1)

Then just base your filter on that column, filtering out all the 1's.

 

[sheller]

Thanks! I did that, and then sorted helper column B by oldest to newest and can do that way, but how can I filter vs. sort and hide? (if I filter out all one, doesn't show anything...). THanks again!
[TABLE="width: 290"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]DEL_PERIOD_START[/TD]
[TD]Helper Day Column[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2016[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
[TR]
[TD="align: right"]8/1/2017[/TD]
[TD="align: right"]1/1/1900[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

First off, I would probably format your helper column as General, so it appears as "1", instead of "1/1/1900". Just less confusing that way.
There is no need to sort by it. Simply include both columns in your Filter. Then click on the Filter drop-down on this helper column and simply uncheck the 1, and it will filter out all those days only.