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?

Hello,

Assuming StartDate is a named range, like this:

="Date Period from "&TEXT(MIN(StartDate),"dd mmm yy")&" to "&TEXT(MAX(StartDate), "dd mmm yy")



In Excel formulas you can't use the + operator to concatenate strings.

doesn't seem to work, i get the following error...

#NAME?

Hi,
In your example in post #1 you used "startdate". I assumed that this was a named range (I mentioned that in my post).
If it isn't a named range, try using a range reference:

="Date Period from "&TEXT(MIN(C3:C10),"dd mmm yy")&" to "&TEXT(MAX(C3:C10), "dd mmm yy")

Adjust C3:C10 as necessary.

Hope that helps...

thanks works perfectly