I have created a Pivot Table and one of the fields contains dates.
How do I take the Min and Max date from the pivot table but I just want to show the Min and Max date on a different cell.
So for example,
CELL A:1 contains ="Date Period from " + Min(startdate) + " to " + Max(startdate)
How do I get this working correctly?
Bookmarks