If you define your days twice, once as a number, and once as the full name, or put off using the full name until you get inside the PivotTableView (which I have never used, so I don't know if you can or not wait until then). So, define the date as a number for the number of the day of the week like so: Format(MyDate, "w", vbMonday). That will give you the days of the week starting with Monday being 1, Tuesday being 2, etc. Then you can sort on this number, rather than on Monday, Tuesday, etc. and they will be in the order you want. As for their names, I don't, as I said, know how to get them where they are not sorted.
Hope this helps at least a little,
It’s unbelievable that no one of functions woks properly in PivotTableView. All gave the same result – starting days from Sunday.
For the present I use your advice for having 2 fields: one for number of week day and another for weekday name. When used together (simultaneously) - days starts from 1 and respectively the first value is Monday ;-)
I think this is enough and more important then sorting the days ;-)