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?