extract date from cell of mixed types
2 views (last 30 days)
Show older comments
[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.
0 Comments
Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!