Hi I formatted a list of dates using custom format ddd on one column and mmm on the next column so each date now shows as a day of the week and a month. I want to be able to filter, sort and pivot the data by day of the week / month, but the filter, sort and pivot only looks at the date value not the displayed value day of the week or month. Please help. Thanks, Simon
Solved by B. B. in 18 mins