I have managed to show date range as it changes on the worksheet title. However when I drag the date range to show say a specific range the date range, the range on the title will not go beyond the range where there is date; for example, I drag the range from 1st January 2018 to 4th May 2018 it only displays on the title 1st January 2018 to 17th April 2018 ( I suspect this is because there is no data beyond that date) . I would however like to still have the title still display till the date I pick regardless. Any help would be appreciated.
Try to use start date and end date parameter value in title.