Clear Filters
Clear Filters

extract date from cell of mixed types

1 view (last 30 days)
Utsav
Utsav on 23 Mar 2016
[dom,txt11,raw11]=xlsread('datasheet.xls',9,'A:A'); yields [] for dom, cell for txt11 and for raw 11 the following is output 'Date' '01/06/2014' '02/06/2014' '05/06/2014' 'NaN' 'NaN' I wish to get the day information from the raw11 data. day(),month(), etc in excel are throwing garbage and I cant use their output to MATLAB.

Sign in to answer this question.

Answers (0)

Categories

Find more on Time Series Objects in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!