how to create date variable or column

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

[James Tursa]

You can't mix formatted dates in with a numeric matrix. Do you actually have a table? Can you show us the first few lines of what you currently have?

[MAHMOUD ALZIOUD]

Thank you this is an example.

[James Tursa]

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]

What do you mean by spreadsheet? I have the data in a matrix in the workspace

Answer 1

[Star Strider]

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
               . . .

[MAHMOUD ALZIOUD]

This is very very helpful thank you very much

[Star Strider]

As always, my pleasure.