filter date - 5th day of of the month

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I just watched a video about excel filter. It says that to find the 5th day of the month (any month) in a date column, just go to filter and in the search box type 05.

I did that, and yes I can see all the date which has for example 05/11/2016, 05/01/2011, 05/04/2001
but that search will also give me the following date too 09/07/2005!

How can I search for the 5th day of any month but do not see date like 11/10/2005 etc

Thank you.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Hi lezawang,

In your column header, when you click on "Filter" button you will initially see "Search (All)" option. However, there is a small drop-down button next to this search bar which allows you to switch between (All), Year, Month and Date options. Simply switch to Date (the search bar will now show "Search Date"), type in "05", and click on "OK".

Hope that helps!
 
Upvote 0
Hi
I just watched a video about excel filter. It says that to find the 5th day of the month (any month) in a date column, just go to filter and in the search box type 05.

I did that, and yes I can see all the date which has for example 05/11/2016, 05/01/2011, 05/04/2001
but that search will also give me the following date too 09/07/2005!

How can I search for the 5th day of any month but do not see date like 11/10/2005 etc

Thank you.

In the search box type 05*
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top