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

2013 6 12
2 个回答
回答已采纳
3 次查看（30 天）

0 个投票

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 !

请先登录，再回答此问题。

 采纳的回答

per isakson
per isakson 2013-6-12
编辑：per isakson 2013-6-12

0 个投票

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.

更多回答（1 个）

saharsahar
saharsahar 2013-6-12

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

per isakson
per isakson 2013-6-13
x2mdate belongs to the Financial Toolbox, which I don't have access to now.
xx=num(1:end,19);MATLABDate = x2mdate(xx,1); looks ok to me.
What does
which x2mdate
say?
saharsahar
saharsahar 2013-6-15
in MATLAB 2009 , it is as follows:
which x2mdate
C:\Program Files\MATLAB\R2009b\toolbox\finance\calendar\x2mdate.m
However in MATLAB 2012b it is:
>> which x2mdate
'x2mdate' not found.
Regardless of x2mdate, is there anyway to match the dates by Excel and MATLAB the same?
Thanks
per isakson
per isakson 2013-6-15
There is a contribution in the File Exchange, xlsdate, which promises to help.
saharsahar
saharsahar 2013-6-23
Great ! Thank you very much . It works perfectly !

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Language Fundamentals 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by