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 3×1 matrix with the correct dates, however the problem is that I want a 3×2 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));
Best Answer