Hi Gaiden

First highlight the column that houses the dates and then on the menu
bar go to Data Text to Columns. Choose "delimited" and then hit
finish.

This should force the values into a valid date / number format.

Then proceed to add as normal, e.g. =SUM(A1:A20)