Filter löschen
Filter löschen

why "datestr" in matlab and date format cell in excell doesnt match?

1 Ansicht (letzte 30 Tage)
Hi all, I have a date number , say 40667. When I am using datestr in matlab , it gives me 5 May, however I have the same number 40667 in excel sheet, when I use the date cell format(by clicking right->format cells-> date) , it gives me 4 May. However as far as I know the 4 May should be the right one. does anybody know why Matlab does not gives me the same result? and why there is mismatch between Matlab and Excel? Appreciated !

Akzeptierte Antwort

per isakson
per isakson am 12 Jun. 2013
Bearbeitet: per isakson am 12 Jun. 2013
Hint:
>> datestr( 40667, 'yyyy-mm-dd HH:MM:SS' )
ans =
0111-05-05 00:00:00
Start of time with Matlab is year 0 and with Excel 1900. See documentation.

Weitere Antworten (1)

saharsahar
saharsahar am 12 Jun. 2013
Thanks per isakson. I got that point and I searched and found "x2mdate" function which will solve the date conversion for me. But now I have problem using this function . Actually I am reading dates from Excel sheet using xlsread. the result will be cell or double : [num,txt,data]=xlsread(filepath); where num is double and data is cell. however the "x2mdate" gives me error for using cell or double formats:
here is my code:
[num,txt,data]=xlsread(filepath);
xx=num(1:end,19);
MATLABDate = x2mdate(xx,1);
and it gives me following error:
Undefined function 'x2mdate' for input arguments of type 'double'
Any help would be appreciated!
  4 Kommentare
per isakson
per isakson am 15 Jun. 2013
There is a contribution in the File Exchange, xlsdate, which promises to help.
saharsahar
saharsahar am 23 Jun. 2013
Great ! Thank you very much . It works perfectly !

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Language Fundamentals finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by