How to add columns with month number and day
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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.
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 19 Feb. 2013
Bearbeitet: Azzi Abdelmalek
am 19 Feb. 2013
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')
3 Kommentare
Andrei Bobrov
am 19 Feb. 2013
Bearbeitet: Andrei Bobrov
am 19 Feb. 2013
[~,M,D] = datevec(datenum...
(2000,1,1+(diff(datenum([2000 1 1;2007 4 30])))',0,0,0));
out = [M,D];
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!