I have not been able to format dates in a Pivot Table since I started using Excel 2016. I have tried a number of fixes on the blog to no avail. The data worksheet has the date formatted as I would like which is 06/02/18. When I add the date to the Pivot Table it pulls in the Month as a column which is not in my original data and then gives me a date column that looks like 2-Jun. I really want the date to look the way it is in the original data. Can anyone help please? I would truly appreciate it. Let me know if you need to see an example. Thank you in advance. I am sure it is something small I am missing.