formatting date in pivot table

P

Patricia

I created a pivot table based on a query with a start and end date. The
pivot table is perfect, except for the format of the dates. It automatically
created the fields based off the start date of 'start date by week' in the
filter area. It works ok, but it is formatted as the # of the week - how can
I get it to show the actual start date of the week, and not the week #?

Thanks
 
Top