Pivot table showing date

Kate Desrochers

Hi All,

We have a bunch of project schedules that list milestones in the primary column (IE Kickoff, First Milestone X, Construction complete, etc). So each milestone has it's own row.

I would like to make a report where the rows are each project (or sheet name) and the columns are the major milestones. The value in the column would be the end date. I was hoping to do this with a pivot, but Pivot cannot put a date as a value. Does anyone have any recommendations on how to achieve this? It seems so simple and straightforward, but impossible!

Gia Thinh

Hi Kate,

Pivot just supports SUM, AVG, COUNT format in the collumn value, not DATE format.

I suggest 2 ways for your use case:

1. Setup the Report with group feature that groups your projects by Milestone column as below screenshot

2. Create a new sheet where the rows are each project and the columns are the milestones. The value in the column is the end date. Using formula to pull in the end date of each milestone from your project sheets

Hope that helps.