Solved my own problem! Here's how to do it:
(If dates are in a row, select row, copy, paste/ transpose to a new column [no header])
Select the column.
Choose Data tab
Text to Columns - opens new box
(choose Delimited), Next
(uncheck all boxes, use "none" for text qualifier), Next
use the ymd option from the Date dropdown.