How can i convert dates from an imported excel file in order to plot?

I have an excel spreadsheet containing dates in the format (mm/dd/yyy) in the first colum and i am attempting to plot these dates against the values in the 2nd column of my spreadsheet.

However i am having issues with my data, i've tried using 'xlsread' and 'readtable' however with 'xlsread' the first column containing the dates doesn't appear. And with 'readtable' i get an error saying 'too many output arguments'

any help would be much appreciated

[JESUS DAVID ARIZA ROYETH]

Could you upload your Excel File here?

Answer 1

[Sahithi Metpalli]

Hi,

To retrieve the column containing dates using xlsread you could use

[output1 output2 output3] = xlsread('abcd.xlsx') 

output1 contains numeric data

output2 contains text data

output3 contains the entire file data

The function readtable read the file data as a table, so use only one output argument

T= readtable('abcd.xlsx')