MATLAB Answers

error xlsread import dates

4 views (last 30 days)
Hi all,
I have a problem when I import dates from an xls file. It contains a column of dates, one of price, dates, price and so on. If I open the file from the Matlab folder, dates are "dd/MM/yyyy".
[price, dates]=xlsread(filename);
With this command I found a problem in the matrix dates in fact it gives me for example "monday-03-08-2010" instead of the "canonical" format "dd/mm/yyyy" and I don't know why. I've already tried with xlsread(filename, 'mm/dd/yyyy') but without solution. Can someone help me?
Thanks a lot
P.s. Matlab version 2019

  0 Comments

Sign in to comment.

Accepted Answer

Rajani Mishra
Rajani Mishra on 13 Apr 2020

  0 Comments

Sign in to comment.

More Answers (0)


Translated by