How to add columns with month number and day

1 次查看（过去 30 天）
Ede gerlderlands
Ede gerlderlands 2013-2-19
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.

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-2-19
编辑：Azzi Abdelmalek 2013-2-19
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 个评论
显示 1更早的评论
Andrei Bobrov
Andrei Bobrov 2013-2-19
编辑：Andrei Bobrov 2013-2-19
[~,M,D] = datevec(datenum...
(2000,1,1+(diff(datenum([2000 1 1;2007 4 30])))',0,0,0));
out = [M,D];

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by