Looks like at least part of my problem is the date value, just did this:

=SUM(IF(M8>"",1,0))

If M8 is a date or number the result is "0", if M8 is text the result is "1".

(My Excel skills are good, not)