I got thousand of sorted dates in Column A (in German Format dd.mm.yyyy).
- Column A is sorted, starting from 01.01.2014 and ending at 31.12.2014.
- There are multiple occurrences of dates, i.e. 07.05.2014 can occur e.g. 20 times.
I would like to be able to count the number of dates ...
... that fall within a specific month (e.g. june 2014 or october 2014) without manually selecting the range and employ the count function.
This operation should be done by using a function, such as count if. I am somehow not able to use this function in this case
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.