February 12, 2016
June 25, 2016
I am using Excel 2010 and this should also work in Excel 2013.
You can refer to the attachment for one way to do what you wanted.
I have created a Due Day field to get the Day portion from the Date.
I have also grouped the Date field by Days, Months and Years.
This will allow you to create the 3 slicers you wanted.
Please note that the day/month/year will only appear in the slicer if they are available in the data. i.e. if the date 31st does not exist in the data, it will not appear in the Due Day slicer etc.
Hope this helps.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas