If I want to write one year date into a excel, like year 2016. I have no idea how to code in matlab. Thanks
1/1/2016
1/2/2016
...
..
12/31/2016

 Akzeptierte Antwort

Azzi Abdelmalek
Azzi Abdelmalek am 13 Apr. 2016
Bearbeitet: Azzi Abdelmalek am 13 Apr. 2016

0 Stimmen

out=datestr(datenum('01/01/2016')+datenum(0:365),'mm/dd/yyyy')
xlswrite('your_file.xlsx',out)

6 Kommentare

Jason
Jason am 13 Apr. 2016
This code will output 01/01/2016, can you remove zero?
datenum
explain it plz
Read the documentation
doc datenum
Jason
Jason am 13 Apr. 2016
I just tried that we need not the code. In Excel, when we enter 1/1/2016, then drag the cell, the following cells will increase the date automatically
out=datestr(datenum('01/01/2016')+(0:365)','mm/dd/yyyy');
Muhammad Usman Saleem
Muhammad Usman Saleem am 13 Apr. 2016
thanks Azzi

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by