I have two columns of excel data which I want to be imported using xlsread based on certain criteria, but I can only get one column to be selected.

I have an excel file with two columns. The first is a numerical date column (e.g. 7.3685e+05) and the next column is text corresponding to each date. I have a matlab code which searches the excel date column based on a date > day1 & < day2 which the user specifies using a calendar GUI. The code is shown below. b returns a 3x1 matrix with the correct dates, however the problem is that I want a 3x2 matrix with the text in the second column. Anyone know how to make it return both columns?

day1 = uigetdate;
day2 = uigetdate;
[~,~,rawMN] = xlsread('PracticeFile','sheet1','M500:N703');

b = rawMN(cellfun(@(x) ~isempty(x) && isnumeric(x) && x>= day1 && x <= day2, rawMN));

Answer 1

[Fangjun Jiang]

b = rawMN(cellfun(@(x) ~isempty(x) && isnumeric(x) && x>= day1 && x <= day2, rawMN),:);

[Kyle Reagan]

Perfect, thanks!