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

 Accepted Answer

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

6 Comments

This code will output 01/01/2016, can you remove zero?
Read the documentation
doc datenum
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');

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!