Performance Summary - Filter by specific dates

[jolly]

Hello,

When I try to filter by specific dates the only values I can see in the year drop-down boxes under 'Date start' and 'Date end' are numbers ranging from 114 to 132. I was expecting to see dates of the years i have inputted in the bet section, ie. 2013, 2014, 2015, 2016 etc... Instead, selecting these values gives me a #VALUE output.

Below is a screenshot of what I mean. Here I was trying to get it to filter by dates from 21 Sep 2014 - 1 Jan 2015:



Is this a bug or is there another way to get this working?

[admin]

Hi Jolly,

That is strange. Have you deleted any rows from the Bets worksheet? Doing so would throw other aspects of the spreadsheet off. Also, make sure your betting data uses the correct format for the date column. Is the Performance Graph working properly?

To the right of the farthest right Performance Summary table are some hidden cells, if you unhide these cells you may be able to debug what's wrong. Unlock the Performance Summary sheet by selecting Tools -> Protect Document and de-select Sheet. The password is sport. The hidden cells are between AM and AW. Highlight these two columns then right click and select Show. The All Years column is where the years data is sourced from in the drop down menu.

Another option is to paste your betting data into a fresh copy of the spreadsheet to see if that fixes things.

If you're still stuck let me know and I'll send you a PM with an email address that you can send the spreadsheet to.