Hi All,
New to the Excel Forum!
I was hoping someone had a method of utilizing a slicer to filter a table using dynamic dates.
EXAMPLE: If I have a 2 line table, with column A being "project name" and column B being "due date", can I create a slicer that will filter by due date with the following style of buttons:
Today
Tomorrow
This Week
Next Week
Bonus points!!!:
can I add a third column, column C: and put in a "complete" yes -or no. then add a "past due" to the slicer. if the due date has come and gone, and the complete column <>"YES", and "past due" is selected in the slicer.. you get the idea!
thanks all.
Bookmarks