[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Display dates in pivot table rather than sum/count etc?

Hello experts,

I have a table to data, basically, I check monthly returns from various departments, and i want to be able to produce a table that will display on a given the month the recertification dates (AA-AD) or if nothing is present remain blank per domain.  I have highlighted in red the heading i want to include.

I thought a pivot table would do this but I cant get it to display dates.
I've attached an example which hopefully explains a little better.

Thank you for your help example10.xlsx
1 Solution
Rory ArchibaldCommented:
Change the field settings to Average (or Min or Max) and set the number format to a date format. See attached.
I have assumed you only have one date per cell in the pivot table.
wisematAuthor Commented:
Thank you i was able to work out exactly what I needed from your solution :)

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now