Write one year date into a excel?

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

 Risposta accettata

Azzi Abdelmalek
Azzi Abdelmalek il 13 Apr 2016
Modificato: Azzi Abdelmalek il 13 Apr 2016
out=datestr(datenum('01/01/2016')+datenum(0:365),'mm/dd/yyyy')
xlswrite('your_file.xlsx',out)

6 Commenti

Jason
Jason il 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 il 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');
thanks Azzi

Accedi per commentare.

Più risposte (0)

Categorie

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by