I want to filter a date in Excel worksheet using "Equals" and date picker.
Example:
I want to filter a date which is 6 April 2022.
The filter work if I use the selection (tick) from the criteria list:
But when I tried to use the the menu option "Equals...."
and use the date picker and select for 6 April 2022,
it returns nothing as seen in the image below:
If I choose the "Before.. / After... / Between..." from the menu option
and use the date picker (or just write 6-apr-22 in the input box), it filter the date as expected.
My question:
Is there any setting which I should change in order that the date picker for the "Equals..." in the Date Filter menu option can work properly ?
if I don't use the date picker, how should I type the date in the input box for the "Equals" ? I've tried 04/06/2022 .... 06/04/2022 ... 6-April-2022 .... 2022-04-06 .... 2022/06/04 ... April-6-2022, but also returns nothing.
FYI, the date setting in my computer is set to dd-mmm-yy
and the date column (TGL) on the worksheet is date formatted (dd-mmm-yy),
while in the formula box it show dd-mm-yy for the cell value.
Any kind of help would be greatly appreciated.
Thank you in advanced.
UPDATE: Just now I've tried by making a pivot table and use that date column as the data source.
Weird, in the pivot table I can filter the date with "Equal" and date picker.
Here is the link for the file :
Anyways if you need to filter using this custom format, you can use the option equal using exactly what you see in the cell 06-abr-22 Any other option won't work
