I am trying to analyze sales based on the actual day of the week. This is very easy to do with a pivot table if I have a column that has just the day of week. Problem is I have a large amount of data and the date is a column, but no separate column with just day of week. Even when custom formatted to "ddd" as cell format, the actual value is still the specific date so it is giving me thousands of individual days on the pivot table. Any suggestions? Certainly dont want to type each day separately.