How to add columns with month number and day

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.

Answer 1

[Azzi Abdelmalek]

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')

[Jan]

+1: Matlab's date function are a good choice. Perhaps this is slightly clearer:

ini = datenum(2000,1,1);
fin = datenum(2007,4,27);
v   = datevec(ini:fin);
...

[Ede gerlderlands]

Thank you very much...

[Andrei Bobrov]

[~,M,D] = datevec(datenum...
                     (2000,1,1+(diff(datenum([2000 1 1;2007 4 30])))',0,0,0));
out = [M,D];