Find current range of dates used in pivot table

[aberry77]

I have a pivot table that has the date located in the Row Labels field. I'd like to place the date range selected in the pivot table in a new worksheet so the end user knows which date they are currently viewing data for.

For instance - If the date selected in the pivot table is set to display data for the current month, I need a cell on a separate worksheet to show that the data is for January 2014. I've attempted to use GETPIVOTDATA but no luck. Any input is appreciated.

 

[cyrilbrd]

Hi,
Getpivodata may be used to retrieve summary data from a PivotTable report.
Would you want to return the date stated in the Row labels? Or would you want to return the range seen in the Row Labels?

 

[cyrilbrd]

given your pivot in Column F
formula in the cell of your choice (not in F) is =IF(MIN(F:F)=MAX(F:F),TEXT(MIN(F:F),"d-mmm-yy"),TEXT(MIN(F:F),"d-mmm-yy")&" to "&TEXT(MAX(F:F),"d-mmm-yy"))
thus would return for the following:

Sum of this
Row Labels	Total		1-Apr-14 to 1-Jun-14
4/1/14	1684
5/1/14	1681
6/1/14	1560
Grand Total	4925

<tbody>
</tbody>

or

Sum of this
Row Labels	Total		1-Jan-14
1/1/14	1388
Grand Total	1388

<tbody>
</tbody>

Would that be close to what you needed?

 

[aberry77]

Would that be close to what you needed?

You, good sir, are a genious!! Thank you so much!

 

[cyrilbrd]

You are welcome.
Thanks for the feedback.