'I'm trying to count the number of instances of a date in a workbook with multiple sheets

I have an Excel workbook that contains daily stock price time series data for a number of different equities for the entire lifetime of each equity. Each equity is in a separate worksheet. I'm interested in finding out how many equities were trading on a specific date, by counting the number of instances of the date that occur in the workbook.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source