[Trick] Using date fields as values in a PivotTable

Often I get the request to build a PivotTable in Excel, that can easily show important/key dates from projects, tasks and milestones. Many end up

Automatically create “Dimension Counts” in your OData Excel reports

Here is a little something nice for those of us creating reports on Project Server data. Previously when working against an OLAP cube in Excel