Insert 'From Date - To Date into pivot table/chart as a title

**Smudge.Smith** · 04-09-2013, 09:22 AM

I'm importing data from a CSV file between specific dates.
The data is then displayed in a pivot table and chart but the dates are not reported against, so are not displayed in any part of the pivot table or chart.
What I need to do is have a title in the pivot table that shows in the chart the start and end date that the report is displaying against.

Anyone help?

Thanx

**Andy Pope** · 04-09-2013, 10:02 AM

If there are no dates in the pivot table you will need to determine the range by using min and max functions on the raw data.
This can then be used in a cell, linked to the title.

for example where date is in range A2:A24

=TEXT(MIN(A2:A24),"dd/mm/yyyy") & " - " & TEXT(MAX(A2:A24),"dd/mm/yyyy")