So I created a pivot table in Excel 2016. My source data (the actual data) contains dates shown like this: YYYY-MM-DD. Now when I created the table, it's showing the dates this way: D-YYYY. I tried changing it by selecting the cells but that didn't work. Can I not change the date format in a pivot table?