var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get Min & Max date from Pivot table field
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?
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...
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...