I have a very long excel sheets, consisting of over 6500 enteries. Problem is not all dates mentioned against each entry are in standard excel format, and because of that, I cannot seggregate the data month or year wise using Excel filter command.
Some dates are in standard format for and because of that, I can seggrate that data year wise. See this screenshot: http://jmp.sh/msVcNZc
As you can see from screenshot, I do get filter option to get even month wise for 2016, similarly for 2014 & 2015 etc., but most of same year data have non-standard date format, which will not be included in that. I hope that clears.
Looking forward to working with you on this project.