Forum Discussion
Removing Dates from Slicer via VBA
Hi, I am using Excel 365; I created a slicer to filter my pivot table by date. I want to remove any dates before 1/1/2023 from the slicer. Is this possible? The code that I have tried (it filter...
Add a helper column to your data and check whether Date is >=01/01/2023.
Move the field into the pivot table or create a slicer and filter on TRUE.
Thank you, below is the help column that I was using. Is there any way to keep the blanks from showing up in the slicer?
=IF(ISBLANK([@[Start Date]]), UNICHAR(160), IF([@[Start Date]] > TODAY(), UNICHAR(160), EOMONTH([@[Start Date]], 0)))
=IF(ISBLANK([@[Start Date]]), UNICHAR(160), IF([@[Start Date]] > TODAY(), UNICHAR(160), EOMONTH([@[Start Date]], 0)))