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

 Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 13 Avr 2016
Modifié(e) : Azzi Abdelmalek le 13 Avr 2016

0 votes

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

6 commentaires

Jason
Jason le 13 Avr 2016
This code will output 01/01/2016, can you remove zero?
datenum
explain it plz
Read the documentation
doc datenum
Jason
Jason le 13 Avr 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 le 13 Avr 2016
thanks Azzi

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by