importing dates into excel

2 views (last 30 days)
antonet
antonet on 23 May 2012
HI all, I issue the command
A=datestr(datenum({'02/11/08'},'dd/mm/yy')+(0:28:38*28),{'dd/mm/yy'});
but A has size 39 by 8 . I want to be 39 by 1 so as to import A in an excel as a column.
  1 Comment
Oleg Komarov
Oleg Komarov on 23 May 2012
You cannot supply the date format as {'dd/mm/yy'}

Sign in to comment.

Accepted Answer

Oleg Komarov
Oleg Komarov on 23 May 2012
Use cellstr()
cellstr(datestr(datenum({'02/11/08'},'dd/mm/yy')+(0:28:38*28),'dd/mm/yy'))

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by