In Excel 2003, you can't use whole columns with SUMPRODUCT... and if column M contain dates, the first one should work.

Can you post a sample workbook showing what you've got and what you are looking to accomplish?

Also ISDATE is not a valid function.