sumproduct formula only counting dates in column

Here is your sheet returned with Text to Columns applied to column M.

Notice that the dates in the first sheet are all in 2001.. whereas the dates in column M are 2011 and 2012...so you will get 0 results if you don't have matches because of the year...