MATLAB: How to add columns with month number and day

for loopif statementtime series

Hi
I have daily observation data which runs for 8 years. The beginning of the data is 1St of January 2000 and ends on 30 April 2007. I wanted to add two columns which are number of month ( Jan=1, feb=2 etc) and number of days(January 1 to 31, February (1 to 28 or 29)). Each four year the number of days in February will be changed. Can you help me with this.
I highly appreciate your help.

Best Answer

a=datenum(2000,1,(1:7*365+122))
v=datevec(datenum(a))
col_month=v(:,2)
col_day=v(:,3)
If you want your date in other format
yourdates=datestr(datenum(2000,1,(1:7*365+122)),'dd-mmm-yyyy')