how to create date variable or column

3 次查看（过去 30 天）
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD 2019-5-10
评论： Star Strider 2019-5-10
Dear All, I have numeric matrix of 3 columns and 100 rows, the 1st column is A and represents day number from 1 to 30, the 2nd column is B and represents month number from 1 to 12, the 3rd one is the year, how can I please create 4th column for the date in the format mm/dd/year? by combining the 3 columns. And then add this column with this format to the matrix as a 4th column. thank you
  4 个评论
显示 2更早的评论
James Tursa
James Tursa 2019-5-10
Readers are going to be reluctant to download an Excel spreadsheet. Can you provide what you have on the MATLAB side? Do you need help in loading the spreadsheet into MATLAB?
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD 2019-5-10
What do you mean by spreadsheet? I have the data in a matrix in the workspace

请先登录，再进行评论。

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

采纳的回答

Star Strider
Star Strider 2019-5-10
Your data have a two-digit year. Assuming ‘10’ means ‘2010’, try this:
D = xlsread('data.xlsx');
Col4 = datetime(fliplr(D)+[2000 0 0], 'Format','MM/dd/yyyy');
producing:
Col4 =
22×1 datetime array
01/01/2010
01/01/2010
01/01/2010
01/01/2010
. . .
Using a table:
Tbl = table(D(:,1),D(:,2),D(:,3),Col4, 'VariableNames',{'Day','Month','Year','All'})
produces:
Tbl =
22×4 table
Day Month Year All
___ _____ ____ __________
1 1 10 01/01/2010
1 1 10 01/01/2010
1 1 10 01/01/2010
1 1 10 01/01/2010
. . .

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by