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)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!