MATLAB Answers

replicating dates and inporting them in an excel file

1 view (last 30 days)
ektor
ektor on 18 May 2012
HI all,
I want to replicate the dates '02/11/2008' '30/11/2008' so at to have
02/11/2008
30/11/2008
02/11/2008
'30/11/2008
So the repetition is every two elements. I apply the following code" dd=[{'02/11/2008' '30/11/2008'} ]';
B = dd(:,ones(4,1));
ss= B(:);
which seems to work but when i try to extract the variable ss in an excel file, then the output of the excel file is
39489
30/11/2008
39489
30/11/2008 39489
30/11/2008
39489
30/11/2008
39489
30/11/2008
Is there anything I can do to fix this problem?

  0 Comments

Sign in to comment.

Accepted Answer

bym
bym on 18 May 2012
change the format of the excel cell to 'date'. You can verify by entering formula in a cell =datevalue("2/11/2008") and the result is 39489

  1 Comment

ektor
ektor on 18 May 2012
Thanks. It works. I was wondering if there is another way to fix it so as not to have to change the format of the excel cell to 'date'. I mean if it is possible to do that correction directly within matlab without having to do the modifications within excel.
Thanks again.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by