Excel Pivot table: Change the Number format of Column label(Date) to "dddd"

by Gangula   Last Updated March 13, 2018 07:01 AM

I have a pivot table with certain columns based on dates. So the column labels are in dates(image below). Excel automatically formats these dates to "dd.mmm" but I would like to just see them as weekdays ("dddd"). I've tried changing the number format of the date field in the field settings.

Pivot table



Related Questions


Excel 2016 - Pivot chart

Updated November 30, 2017 23:01 PM

Filter Excel Data

Updated February 05, 2018 10:01 AM