Success! I converted the table back to a normal range and then duplicated the Order Date column as you suggested, and then copied and pasted the criteria headers elsewhere on the worksheet. While doing this and looking at the example template I’d downloaded, I noticed the table dates were in the UK date format but the criteria dates entered were in US date format. When I changed them to UK format the result immediately changed from 0 to 8646.

For some reason when clicking on ‘enable editing’ after scanning the downloaded template, this is when the value changed. Before that it shows as 8646! So, that’s good to know for the future to double check everything as I’m not 100% observant when it comes to that sort of thing.

You’ve been a great help. I wouldn’t have worked this out myself or discovered the date format discrepancy if I hadn’t gone back to look at this again and duplicate the column etc. Thanks a million.
Cheers