Cell array into numeric array. Date data type handling.

I have an excel file with the collumn A full of dates of this type: 01/01/2017 00:00 for example. When I import it to MATLAB, is imported as a cell array. I need to be able to treat those cell arrays as dates in MATLA abd make conditional operations with them. Can you help in a way I can do so?

Answer 1

[Guillaume]

Use the modern readtable rather than the ancient xlsread. readtable parses dates properly.

[Patricia Alejandra Palacios Romero]

hey, thank you! that really helped me.

[Peter Perkins]

Also, probably take one extra step and use table2timetable.