The spreadsheet I'm using for a pivot table contains a calculated date field
(Date+30). This NewDate field is used in the pivot table. I've changed the
date format in both the data spreadsheet and the pivot table to mm/dd/yy, but
when the table is refreshed the NewDate field reverts to mm/dd/yyyy hh:mm. I
imagine this has to do with the calculation... What can I do so that I the
table can be refreshed, but keep the mm/dd/yy format?

Thanks in advance,
Janice