Date(class:cell) type problem

I have cell array containing only dates(imported from excel) I want to change them into YYYYMMDD type. Datestr doesn't work and I tried cell2mat then datestr, but the result is quite wierd since many of the dates are missing from the result. I tried to export to excel to set the date type but some of them remain the same. So I am wondering how can I deal with this? driving me nuts. Thank you so much!

Answer 1

[Andrei Bobrov]

cellfun(@(c)datestr(c,'yyyymmdd'),cellarraydate,'un',0)

[Az]

Dear andrei bobrov,

Thanks for your answer.

But it didn't work with my file.

Is there anyway I can Upload the file to you?

[Andrei Bobrov]

of course

Answer 2

[Anthony Smith]

datestr seems to only operate on strings so you probably need to access the contents of each cell individually rather than using an array operation. Using datestr format 29 for example:

for i=1:size(cellArray,1)
    for j=1:size(cellArray,2)
        newFormattedString = datestr(cellArray{i,j} ,29);
    end
end

[Az]

Dear Anthony Smith,

Thanks for your answer.

But it didn't work with my file.

Is there anyway I can Upload the file to you?