Index in position 2 exceeds array bounds.（keep appearing this although I tried different arrays）

[tempData,~] =xlsread(rawDataFile,'Sheet1');
releaseCal.refP         =x2mdate(tempData(:,1));
releaseCal.releaseDates =x2mdate(tempData(:,2:end));

[Yiming Ji]

in line two

[Chunru]

check the size of x2mdate and the value of tempData(:,1) and ensure tempData(:,1) is the right index value to x2mdate

[Yiming Ji]

x2mdate is a matlab command to convert excel date number into matlab date number

Answer 1

[KSSV]

xlsread is obselete. USe readtable.

T = readtable(rawDataFile,'Sheet1');

You can convert it to the array using table2array. You can access any column using T.(1), T.(2), etc. While extracting any column keep the dimensions in mind.

[Yiming Ji]

T = readtable('1.xlsx');

A = table2array(T);

releaseCal.refP =x2mdate(A(2:end,1));%reference period

releaseCal.releaseDates =x2mdate(A(2:35,2:end));

NOW MY MATLAB TELLING ME THIS

Error using x2mdate (line 57)

Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more subscripts) is not supported. Use a row subscript and a variable subscript.

[KSSV]

Why you are using x2mdate?

[Yiming Ji]

Because the sheet 1 is an excel consisting of a table of excel dates. try to convert that into matlab date here